[U2] RE: [UV] is there an equivalent to the UD ALL UniQuery keyword?
To all you UniVerse experts out there. A site I know is moving from UniData on VMS to UniVerse on UNIX. Don't ask why, they just decided that was the path they wanted to go down. Anyhow, they've got used to the ability in UniData to LIST filename ALL and see everything. They're a bit surprised that this doesn't work in UniVerse. Any ideas? Of course we could write them a BASIC program called LIST that scans the command for the keyword ALL and if it finds it, works out what ALL means in the context of that file before invoking the real UniVerse LIST with a modified command, but I'd like to exhaust other options first. Cheers, Ken ALL Syntax ... filename ALL Description The UniQuery ALL keyword displays every data (D-type) attribute defined in the dictionary of filename. ALL does not display virtual (V-type) attributes. Example In the following example, the ALL keyword lists every D-type attribute in the INVENTORY file: :LIST INVENTORY ALL LIST INVENTORY ALL 10:25:34 Mar 25 1999 1 Product Number 15001 Inventory Date 08/20/1995 Inventory Time 01:00PM Product Name Modem Features 14.4K Internal V34 Color Quantity Price Reorder N/A 7486 $119.00 40 Product Number 35000 Inventory Date 07/09/1995 Inventory Time 10:00AM Product Name Speaker Features 250W, Direct/reflecting Color Quantity Price Reorder Black 148 $198.93 50 Charcoal 125 $198.93 50 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] RE: [UV] is there an equivalent to the UD ALL UniQuery keyword?
Create an @ phrase in the DICT of the file with all the field name. This will also honour any associations. You could also create an @ALL phrase if you already have an @ phrase in the DICT LIST filename @ALL ED DICT CM @ 0001= PH 0002 = COMPANY ADD1 ADD2 ADD3 PCODE PROV ORDER.DATES ORDER.VALUES Alternatively, if no @ phrase exists in the DICT, type REVISE filename and an @ phrase with the first 50 fields will be automatically created in the DICT - at least it does that in INFORMATION and PI/OPEN flavours. Regards Ian Stuart Ken Wallis wrote: To all you UniVerse experts out there. A site I know is moving from UniData on VMS to UniVerse on UNIX. Don't ask why, they just decided that was the path they wanted to go down. Anyhow, they've got used to the ability in UniData to LIST filename ALL and see everything. They're a bit surprised that this doesn't work in UniVerse. Any ideas? Of course we could write them a BASIC program called LIST that scans the command for the keyword ALL and if it finds it, works out what ALL means in the context of that file before invoking the real UniVerse LIST with a modified command, but I'd like to exhaust other options first. Cheers, Ken ALL Syntax ... filename ALL Description The UniQuery ALL keyword displays every data (D-type) attribute defined in the dictionary of filename. ALL does not display virtual (V-type) attributes. Example In the following example, the ALL keyword lists every D-type attribute in the INVENTORY file: :LIST INVENTORY ALL LIST INVENTORY ALL 10:25:34 Mar 25 1999 1 Product Number 15001 Inventory Date 08/20/1995 Inventory Time 01:00PM Product Name Modem Features 14.4K Internal V34 Color Quantity Price Reorder N/A 7486 $119.00 40 Product Number 35000 Inventory Date 07/09/1995 Inventory Time 10:00AM Product Name Speaker Features 250W, Direct/reflecting Color Quantity Price Reorder Black 148 $198.93 50 Charcoal 125 $198.93 50 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ___ DISCLAIMER ___ This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. ___ DISCLAIMER ___ This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] RE: [UV] is there an equivalent to the UD ALL UniQuery keyword?
Not for nothing but I've worked on both platforms and I prefer Ud to Uv. My 1 cent - Original Message - From: Ken Wallis [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Thursday, December 01, 2005 11:07 PM Subject: [U2] RE: [UV] is there an equivalent to the UD ALL UniQuery keyword? To all you UniVerse experts out there. A site I know is moving from UniData on VMS to UniVerse on UNIX. Don't ask why, they just decided that was the path they wanted to go down. Anyhow, they've got used to the ability in UniData to LIST filename ALL and see everything. They're a bit surprised that this doesn't work in UniVerse. Any ideas? Of course we could write them a BASIC program called LIST that scans the command for the keyword ALL and if it finds it, works out what ALL means in the context of that file before invoking the real UniVerse LIST with a modified command, but I'd like to exhaust other options first. Cheers, Ken ALL Syntax ... filename ALL Description The UniQuery ALL keyword displays every data (D-type) attribute defined in the dictionary of filename. ALL does not display virtual (V-type) attributes. Example In the following example, the ALL keyword lists every D-type attribute in the INVENTORY file: :LIST INVENTORY ALL LIST INVENTORY ALL 10:25:34 Mar 25 1999 1 Product Number 15001 Inventory Date 08/20/1995 Inventory Time 01:00PM Product Name Modem Features 14.4K Internal V34 Color Quantity Price Reorder N/A 7486 $119.00 40 Product Number 35000 Inventory Date 07/09/1995 Inventory Time 10:00AM Product Name Speaker Features 250W, Direct/reflecting Color Quantity Price Reorder Black 148 $198.93 50 Charcoal 125 $198.93 50 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: [UV] is there an equivalent to the UD ALL UniQuery keyword?
How about just adding a phrase to each DICT called ALL that lists all of the D-type items? eg: DICT CUST.MST ALL 001: PH 002: CUST.NAME CUST.ADDR1 CUST.ADDR2 CUST.CITY ... etc You could even write a simple program to SELECT DICT filename WITH TYPE = 'D' BY LOC, and then loop through create the ALL phrases for that particular file. One time setup, then it's available for their use. Larry Hiscock Western Computer Service -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ken Wallis Sent: Thursday, December 01, 2005 8:07 PM To: u2-users@listserver.u2ug.org Subject: [U2] RE: [UV] is there an equivalent to the UD ALL UniQuery keyword? To all you UniVerse experts out there. A site I know is moving from UniData on VMS to UniVerse on UNIX. Don't ask why, they just decided that was the path they wanted to go down. Anyhow, they've got used to the ability in UniData to LIST filename ALL and see everything. They're a bit surprised that this doesn't work in UniVerse. Any ideas? Of course we could write them a BASIC program called LIST that scans the command for the keyword ALL and if it finds it, works out what ALL means in the context of that file before invoking the real UniVerse LIST with a modified command, but I'd like to exhaust other options first. Cheers, Ken ALL Syntax ... filename ALL Description The UniQuery ALL keyword displays every data (D-type) attribute defined in the dictionary of filename. ALL does not display virtual (V-type) attributes. Example In the following example, the ALL keyword lists every D-type attribute in the INVENTORY file: :LIST INVENTORY ALL LIST INVENTORY ALL 10:25:34 Mar 25 1999 1 Product Number 15001 Inventory Date 08/20/1995 Inventory Time 01:00PM Product Name Modem Features 14.4K Internal V34 Color Quantity Price Reorder N/A 7486 $119.00 40 Product Number 35000 Inventory Date 07/09/1995 Inventory Time 10:00AM Product Name Speaker Features 250W, Direct/reflecting Color Quantity Price Reorder Black 148 $198.93 50 Charcoal 125 $198.93 50 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: [UV] is there an equivalent to the UD ALL UniQuery keyword?
An alternative to using Larry's suggestion of writing a program to create a phrase of all the D types, you can use REVISE filename which will automatically create an @REVISE phrase in the dictionary containing all the D-types. You can then just rename @REVISE to ALL. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Larry Hiscock Sent: Friday, 2 December 2005 1:39 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] RE: [UV] is there an equivalent to the UD ALL UniQuery keyword? How about just adding a phrase to each DICT called ALL that lists all of the D-type items? eg: DICT CUST.MST ALL 001: PH 002: CUST.NAME CUST.ADDR1 CUST.ADDR2 CUST.CITY ... etc You could even write a simple program to SELECT DICT filename WITH TYPE = 'D' BY LOC, and then loop through create the ALL phrases for that particular file. One time setup, then it's available for their use. Larry Hiscock Western Computer Service 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 To unsubscribe please visit http://listserver.u2ug.org/