UniVerse RetrieVe, how can I request a file for all its column values?

Question

Kind of my next answer to the question about finding column names.

In UniVerse, you cannot query a file for all its columns, unless the phrase @in your file dictionary is set to all columns of the tables. If this is not the case, how do you query the table for all the values ​​of your columns?

So, I can get a general list of columns (column name and display name) using:

LIST DICT file NAME

This will return a list of all columns and their display names. How can I then query the table for all the columns that it has?

LIST file

Will only request for LIST file @id(@id is the only one in @).

UPDATE I found a blog - a living person who uses a version of UniVerse older than me !! where he complains about the same thing, but says that there is no solution, shy of updating @with all the columns, please god, someone will prove to him (Dan Watts) wrong.

, 200 , SELECT * 200 ? , 200 "@". , , "@". ! UniVerses ODBC , , , . , IBM-ese UniVerse ODBC.

Answer 1

.

, , LIST.ITEM LIST-ITEM . , :

>LIST.ITEM ACTIVITY
LIST.ITEM ACTIVITY 06:52:10pm  14 Jan 2010  PAGE    1

1
001 LEXMARK MULTI PRINT
002 THD
003 PJ
007 10355
009 Y
010 CAGNEW
011 15349
012 52111
014 1ý2ý3ý4ý5
015 Deinstall Make/ModelýDeinstall LocationýSigned Off ByýData/Voice AvailableýR
elocated Location
016 1ý2ý3ý4ý5

2
001 OMN
002 OMN
003 PJ
004 OMN*8437
005 6
009 N
010 CAGNEW
011 15349
012 51958

>  

- , - :

OPEN "ACTIVITY" TO F.ACTIVITY ELSE STOP
SELECT F.ACTIVITY
LOOP
    READNEXT ID ELSE EXIT
    READ R.ACTIVITY FROM F.ACTIVITY, ID THEN
    ..................
    END
REPEAT

Answer 2

LIST.ITEM .

Answer 3

Try

LIST file ALL

, , , . ?

, Rocket Software U2. .

, , . U2.

Answer 4

:

IBM ADO.NET Dan , UniVerse ( UniData) . IBM U2 ( UniVerse) Rocket Software, .

-, DICTionaries . @ CRT. @SELECT , SELECT SQL.

>ED DICT VOC @SELECT
New record.

----: I
0001= PH
0002= NAME TYPE
0003= 
Bottom at line 2.
----: FI
"@SELECT" filed in file "DICT VOC".
>SELECT * FROM VOC;
NAME.......... TYPE

VERIFY.SQL     V
DIVX           V
INVISIBLE      K
QUIT.KEY       X
LEADING        K
DELETE.LIST    V
...

Answer 5

Universe/Pick RECALL/RETRIEVE/ENGLISH/LIST. VOC , F1, F2, F3 .., S D. , 10 , , " 1". "* A1", "* A2" .., , , .

, F1 ( - ), VOC. , :

LIST {filename} F1 F2 F3

. , , , .

, , , "ALL.FIELDS", gazillion "F1". :

001: PH 002: F1 F2 F3 F4 F5 F6 F7 F8 F9 {....} F200

, @, , . "ALL.FIELDS" .

, , - , , , . , , , .

, , , "". , SELECT "A" "ALL.FIELD", . , , , "S", "I" "D".

Personally, I find loading the @dictionary element with each field, which can be annoying when you do everyday things inside a PICK environment. Typically, you want material that fits well with the 80 column display to have sorting and general parameters that make sense. I would prefer the SQL material to be customized and named accordingly.