The program does not touch the dict, it does a direct read against every row in the table and summarises what literal columns are in use. The dict of a file may miss some columns and introduce new virtual columns.
I am a bit lost as to what it is that you are after - either way you probably need to right some basic code to get teh data from dict items or real data from inside the row or whatever it is you are trying to do... -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Evan Carroll Sent: 25 January 2010 19:03 To: U2 Users List Subject: Re: [U2] UniVerse RetreiVe how do I query a file for all of its column's values? On Thu, Jan 21, 2010 at 10:29 AM, Symeon Breen <[email protected]> wrote: > Example program (nb this has been posted before in this group - the group > is searchable at nabble ) This one doesn't seem to do what I wanted. Running it against the VOC I get this: >RUN ANALYSEFILE ENTER FILE NAME :VOC Analysis for 793 records of VOC Null Numeric Text Min len Max len Attribute 1 793 1 13 Attribute 2 1 404 388 1 112 Attribute 3 11 385 1 100 Attribute 4 11 258 1 161 Attribute 5 56 53 1 12 Attribute 6 57 18 1 18 Attribute 7 55 6 1 1 Attribute 8 55 6 4 7 Attribute 9 1 57 1 11 Attribute 10 3 1 4 Finished. It is still a helpful suggestion because it obviously visits the dic and extracts useful information pertaining to the schema. -- Evan Carroll System Lord of the Internets _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
