Re: [U2] UniVerse RetreiVe how do I query a file for all of itscolumn's values?

2010-01-25 Thread Brutzman, Bill
Consider using UniBasic.

--Bill

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Evan Carroll
Sent: Monday, January 25, 2010 2:03 PM
To: U2 Users List
Subject: Re: [U2] UniVerse RetreiVe how do I query a file for all of 
itscolumn's values?

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

Analysis for 793 records of VOC

 NullNumeric   TextMin lenMax len
Attribute1  793  1 13
Attribute2  1404388  1112
Attribute3 11   385  1100
Attribute4 11   258  1161
Attribute5 5653  1 12
Attribute6 5718  1 18
Attribute7 55 6  1  1
Attribute8 55 6  4  7
Attribute9  157  1 11
Attribute   103  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
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] UniVerse RetreiVe how do I query a file for all of itscolumn's values?

2010-01-20 Thread Womack, Adrian

Here's another simple option:

Use REVISE (or ENTRO, MODIFY, etc) on the file - this will automatically
create an @REVISE phrase in the file's dictionary.

You could then use LIST filname @REVISE to see all the fields.

(Note: REVISE will only create the @REVISE phrase if you don't already
have an @ phrase in the dictionary).

Alternatively write a simple program to SELECT all the D-types in the
dictionary and append their names into a string and then build up a LIST
statement containing all the field names.


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan
Fitzgerald
Sent: Thursday, 21 January 2010 12:39 PM
To: 'U2 Users List'
Subject: Re: [U2] UniVerse RetreiVe how do I query a file for all of
itscolumn's values?

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 a proc. Sounds like you have options...



DISCLAIMER:
Disclaimer.  This e-mail is private and confidential. If you are not the 
intended recipient, please advise us by return e-mail immediately, and delete 
the e-mail and any attachments without using or disclosing the contents in any 
way. The views expressed in this e-mail are those of the author, and do not 
represent those of this company unless this is clearly indicated. You should 
scan this e-mail and any attachments for viruses. This company accepts no 
liability for any direct or indirect damage or loss resulting from the use of 
any attachments to this e-mail.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users