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
Post a Comment