u2 - UniVerse RetrieVe how do I query a file for all of its columns' values? -


kind of follow my self-answered question finding column names.

in universe can't query file of columns unless @ phrase in file's dictionary set of tables columns. if isn't, how query table of columns' values?

so can total column listing (column name & display name) using:

list dict file name 

this return listing of columns , display names. how query table of columns has?

list file 

will query list file @id (@id thing in @).

update found a blog -- living breathing person id using version of universe older mine!! complains same thing, says there no solution shy of updating @ of columns, please god prove him (dan watts) wrong.

what if have 200 column table , want select * return 200 columns? sorry, you’ll have enter 200 column names in "@" record. , if add, delete or rename column, you’ll have remember edit "@" record. feel pain! cumbersome approach dates universe’s odbc driver, , suppose can’t change without breaking lot of applications. can find details described in inscrutable ibm-ese in universe odbc guide.

list not work on universe.

one thing can list.item or list-item depending on flavor. list every attribute in file has data in this:

>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  >   

if you're looking data write program , this:

open "activity" f.activity else stop select f.activity loop     readnext id else exit     read r.activity f.activity, id     ..................     end repeat 

Comments

Popular posts from this blog

unicode - Are email addresses allowed to contain non-alphanumeric characters? -

C#: Application without a window or taskbar item (background app) that can still use Console.WriteLine() -

c++ - Convert big endian to little endian when reading from a binary file -