On Thu, Jan 21, 2010 at 10:29 AM, Symeon Breen syme...@gmail.com 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
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
Hi Evan
This might be of some help .. It's a quick hacky utility I wrote to list all
fields in a file for a given set of record ids.
You can customize it to your own use.
Just to echo what others have said: this isn't necessarily the best way to
get to the content, since UniVerse dictionaries
Example program (nb this has been posted before in this group - the group
is searchable at nabble )
* ANALYSEFILE
* By Symeon Breen - to analyse a data file and give a resume of what
attributes are used
* Usage - ANALYSEFILE {file name}
s...@sentence
IF Sen[1,4]=RUN THEN
I'm looking to dump the data in an easily parseble fashion such that I
can use it in a different environment.
What we have here is a difference in concept. While a relational
environment has a schema which must clearly define the database so that
the one big tool (SQL) is able to do all of
Hi Evan,
It is not often you would do something like this as it is generally not
required in the U2 World. We may be able to provide you with better
solutions if we understood what you are trying to achieve by listing
every column?
Unidata/UniVerse files are a lot more complex than SQL Tables in
So, the choices are to edit the @ item in the dict add all of the columns,
or write a basic program that reads Rec, then outputs Rec1, Rec2, etc. A
third solution would be to copy the F1 dictionary item to F2, F3, F4, etc.,
change the attribute (column) field to match, then list 'em all, maybe in
It is not often you would do something like this as it is generally not
required in the U2 World. We may be able to provide you with better
solutions if we understood what you are trying to achieve by listing
every column?
I have a proprietary database I'm connecting to, all of the fieldnames