RE: [U2] How do we get unique records from Universe file(Table)
Or, if you're after the records for which there is only one instance SELECT columnlist, COUNT(*) FROM filename GROUP BY columnlist HAVING COUNT(*) = 1; --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] How do we get unique records from Universe file(Table)
Define unique. Gordon J. Glorfield Sr. Applications Developer MAMSI (A UnitedHealth Company) 301-360-8839 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Thursday, August 12, 2004 10:05 AM To: [EMAIL PROTECTED] Subject: [U2] How do we get unique records from Universe file(Table) Hi, Can anybody help me in retriving the unique(distinct) records from Universe file tax in advance regards Reddy --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] How do we get unique records from Universe file(Table)
Hi, What do you mean by 'unique'? Can you show us an example of what you want to do. All records in a universe file have a unique identifier (ID). Les. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 12 August 2004 15:05 To: [EMAIL PROTECTED] Subject: [U2] How do we get unique records from Universe file(Table) Hi, Can anybody help me in retriving the unique(distinct) records from Universe file tax in advance regards Reddy --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ This e-mail and any attachments are confidential and intended solely for the use of the addressee only. If you have received this message in error, you must not copy, distribute or disclose the contents; please notify the sender immediately and delete the message. This message is attributed to the sender and may not necessarily reflect the view of Travis Perkins plc or its subsidiaries (Travis Perkins). Agreements binding Travis Perkins may not be concluded by means of e-mail communication. E-mail transmissions are not secure and Travis Perkins accepts no responsibility for changes made to this message after it was sent. Whilst steps have been taken to ensure that this message is virus free, Travis Perkins accepts no liability for infection and recommends that you scan this e-mail and any attachments. Part of Travis Perkins plc. Registered Office: Lodge Way House, Lodge Way, Harlestone Road, Northampton, NN5 7UG. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] How do we get unique records from Universe file(Table)
Do you mean: SELECT foo WITH foo1 = foo2 SAVING UNIQUE foo3 This gives you a select list of unique foo3 values. Oh, and no thanks, I have enough tax. Best, David Beahm [EMAIL PROTECTED] wrote: Hi, Can anybody help me in retriving the unique(distinct) records from Universe file tax in advance regards Reddy -- --- This email is confidential and intended solely for the use of the individual to whom it is addressed. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error, please contact the sender. --- --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] How do we get unique records from Universe file(Table)
You can setup a DICTIONARY ITEM that concatantes both values IE. ED DICT FILE MFGPARTNO MFGPARTNO 001: I 002: MFG.NO:PART.NO 003: 004: combo 005: 20L 006: S Assuming they are both single valued fields: Then SELECT ORDERS SAVING UNIQUE MFGPARTNO George -Original Message- From: Chauhan, Savita [mailto:[EMAIL PROTECTED] Sent: Thursday, August 12, 2004 11:09 AM To: [EMAIL PROTECTED] Subject: RE: [U2] How do we get unique records from Universe file(Table) Can we save a unique combination of more than one fields, instead of just saving the unique @ID ie, SELECT ORDERS SAVING UNIQUE MFG.NO PART.NO Will this save records with unique combination of mfg.no and part.no? Savita. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Pingilley, Ron Sent: Thursday, August 12, 2004 9:46 AM To: '[EMAIL PROTECTED]' Subject: RE: [U2] How do we get unique records from Universe file(Table) tax in advance -- sounds like the US Government! :) If you're doing a SELECT at tcl, try adding SAVING UNIQUE to your statement. Here's an example: SELECT ORDERS WITH ORDER.DATE 8/1 PART.NUMBER ...10456 items selected SELECT INVENTORY SAVING UNIQUE @ID ...395 items selected SAVE.LIST AUG.PARTS 1st step selected the PART.NUMBER field from the ORDERS file, with lots of duplicate part numbers showing up. The 2nd step pared that list down to just unique part numbers. --Ron P. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, August 12, 2004 9:05 AM To: [EMAIL PROTECTED] Subject: [U2] How do we get unique records from Universe file(Table) Hi, Can anybody help me in retriving the unique(distinct) records from Universe file tax in advance regards Reddy --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] How do we get unique records from Universe file(Table)
Hi George, It's always a good idea when concatenating to be sure that you put in a character to separate the fields so that later on it's easy to take them back apart if necessary. Otherwise you won't know where the mfg.no stops and the part.no starts. 002:MFG.NO:|:PART.NO Allen E. Elwood Senior Programmer Analyst Direct (818) 361-5251 Fax(818) 361-5251 Cell(818) 359-8162 Home (818) 361-7217 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of George Gallen Sent: Thursday, August 12, 2004 08:31 To: [EMAIL PROTECTED] Subject: RE: [U2] How do we get unique records from Universe file(Table) You can setup a DICTIONARY ITEM that concatantes both values IE. ED DICT FILE MFGPARTNO MFGPARTNO 001: I 002: MFG.NO:PART.NO 003: 004: combo 005: 20L 006: S Assuming they are both single valued fields: Then SELECT ORDERS SAVING UNIQUE MFGPARTNO George --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] How do we get unique records from Universe file(Table)
Can this (selecting only those order IDs which have unique combination of Mfg.No and Part.No) be done without having to create an intermediate dictionary item? Savita Chauhan, Programmer/Analyst x:1754 Central Texas College. --- Change is the only Constant. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of George Gallen Sent: Thursday, August 12, 2004 10:31 AM To: [EMAIL PROTECTED] Subject: RE: [U2] How do we get unique records from Universe file(Table) You can setup a DICTIONARY ITEM that concatantes both values IE. ED DICT FILE MFGPARTNO MFGPARTNO 001: I 002: MFG.NO:PART.NO 003: 004: combo 005: 20L 006: S Assuming they are both single valued fields: Then SELECT ORDERS SAVING UNIQUE MFGPARTNO George -Original Message- From: Chauhan, Savita [mailto:[EMAIL PROTECTED] Sent: Thursday, August 12, 2004 11:09 AM To: [EMAIL PROTECTED] Subject: RE: [U2] How do we get unique records from Universe file(Table) Can we save a unique combination of more than one fields, instead of just saving the unique @ID ie, SELECT ORDERS SAVING UNIQUE MFG.NO PART.NO Will this save records with unique combination of mfg.no and part.no? Savita. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Pingilley, Ron Sent: Thursday, August 12, 2004 9:46 AM To: '[EMAIL PROTECTED]' Subject: RE: [U2] How do we get unique records from Universe file(Table) tax in advance -- sounds like the US Government! :) If you're doing a SELECT at tcl, try adding SAVING UNIQUE to your statement. Here's an example: SELECT ORDERS WITH ORDER.DATE 8/1 PART.NUMBER ...10456 items selected SELECT INVENTORY SAVING UNIQUE @ID ...395 items selected SAVE.LIST AUG.PARTS 1st step selected the PART.NUMBER field from the ORDERS file, with lots of duplicate part numbers showing up. The 2nd step pared that list down to just unique part numbers. --Ron P. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, August 12, 2004 9:05 AM To: [EMAIL PROTECTED] Subject: [U2] How do we get unique records from Universe file(Table) Hi, Can anybody help me in retriving the unique(distinct) records from Universe file tax in advance regards Reddy --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] How do we get unique records from Universe file(Table)
check out EVAL in the documentation Rich Chauhan, Savita wrote: Can this (selecting only those order IDs which have unique combination of Mfg.No and Part.No) be done without having to create an intermediate dictionary item? snip --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] How do we get unique records from Universe file(Table)
Savita: You can create an 'on-the-fly' version rather than having to actually add a DICT item by using EVAL: SELECT ORDERS SAVING UNIQUE EVAL MFG.NO : '|' : PART.NO Harold Oaks Sr. Analyst/Programmer Clark County, WA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Chauhan, Savita Sent: Thursday, August 12, 2004 10:56 AM To: [EMAIL PROTECTED] Subject: RE: [U2] How do we get unique records from Universe file(Table) Can this (selecting only those order IDs which have unique combination of Mfg.No and Part.No) be done without having to create an intermediate dictionary item? Savita Chauhan, Programmer/Analyst x:1754 Central Texas College. --- Change is the only Constant. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of George Gallen Sent: Thursday, August 12, 2004 10:31 AM To: [EMAIL PROTECTED] Subject: RE: [U2] How do we get unique records from Universe file(Table) You can setup a DICTIONARY ITEM that concatantes both values IE. ED DICT FILE MFGPARTNO MFGPARTNO 001: I 002: MFG.NO:PART.NO 003: 004: combo 005: 20L 006: S Assuming they are both single valued fields: Then SELECT ORDERS SAVING UNIQUE MFGPARTNO George -Original Message- From: Chauhan, Savita [mailto:[EMAIL PROTECTED] Sent: Thursday, August 12, 2004 11:09 AM To: [EMAIL PROTECTED] Subject: RE: [U2] How do we get unique records from Universe file(Table) Can we save a unique combination of more than one fields, instead of just saving the unique @ID ie, SELECT ORDERS SAVING UNIQUE MFG.NO PART.NO Will this save records with unique combination of mfg.no and part.no? Savita. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Pingilley, Ron Sent: Thursday, August 12, 2004 9:46 AM To: '[EMAIL PROTECTED]' Subject: RE: [U2] How do we get unique records from Universe file(Table) tax in advance -- sounds like the US Government! :) If you're doing a SELECT at tcl, try adding SAVING UNIQUE to your statement. Here's an example: SELECT ORDERS WITH ORDER.DATE 8/1 PART.NUMBER ...10456 items selected SELECT INVENTORY SAVING UNIQUE @ID ...395 items selected SAVE.LIST AUG.PARTS 1st step selected the PART.NUMBER field from the ORDERS file, with lots of duplicate part numbers showing up. The 2nd step pared that list down to just unique part numbers. --Ron P. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, August 12, 2004 9:05 AM To: [EMAIL PROTECTED] Subject: [U2] How do we get unique records from Universe file(Table) Hi, Can anybody help me in retriving the unique(distinct) records from Universe file tax in advance regards Reddy --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] How do we get unique records from Universe file(Table)
YES. SELECT FILENAME SAVING UNIQUE EVAL MFGNO:PARTNO or SELECT FILENAME SAVING UNIQUE EVAL MFGNO:_:PARTNO George -Original Message- From: Chauhan, Savita [mailto:[EMAIL PROTECTED] Sent: Thursday, August 12, 2004 1:56 PM To: [EMAIL PROTECTED] Subject: RE: [U2] How do we get unique records from Universe file(Table) Can this (selecting only those order IDs which have unique combination of Mfg.No and Part.No) be done without having to create an intermediate dictionary item? Savita Chauhan, Programmer/Analyst x:1754 Central Texas College. --- Change is the only Constant. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of George Gallen Sent: Thursday, August 12, 2004 10:31 AM To: [EMAIL PROTECTED] Subject: RE: [U2] How do we get unique records from Universe file(Table) You can setup a DICTIONARY ITEM that concatantes both values IE. ED DICT FILE MFGPARTNO MFGPARTNO 001: I 002: MFG.NO:PART.NO 003: 004: combo 005: 20L 006: S Assuming they are both single valued fields: Then SELECT ORDERS SAVING UNIQUE MFGPARTNO George -Original Message- From: Chauhan, Savita [mailto:[EMAIL PROTECTED] Sent: Thursday, August 12, 2004 11:09 AM To: [EMAIL PROTECTED] Subject: RE: [U2] How do we get unique records from Universe file(Table) Can we save a unique combination of more than one fields, instead of just saving the unique @ID ie, SELECT ORDERS SAVING UNIQUE MFG.NO PART.NO Will this save records with unique combination of mfg.no and part.no? Savita. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Pingilley, Ron Sent: Thursday, August 12, 2004 9:46 AM To: '[EMAIL PROTECTED]' Subject: RE: [U2] How do we get unique records from Universe file(Table) tax in advance -- sounds like the US Government! :) If you're doing a SELECT at tcl, try adding SAVING UNIQUE to your statement. Here's an example: SELECT ORDERS WITH ORDER.DATE 8/1 PART.NUMBER ...10456 items selected SELECT INVENTORY SAVING UNIQUE @ID ...395 items selected SAVE.LIST AUG.PARTS 1st step selected the PART.NUMBER field from the ORDERS file, with lots of duplicate part numbers showing up. The 2nd step pared that list down to just unique part numbers. --Ron P. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, August 12, 2004 9:05 AM To: [EMAIL PROTECTED] Subject: [U2] How do we get unique records from Universe file(Table) Hi, Can anybody help me in retriving the unique(distinct) records from Universe file tax in advance regards Reddy --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] How do we get unique records from Universe file(Table)
Unless you have a PARTID file that has it's ID as the MFGCODE and PARTCODE, then it would work. If this is an invoice and your trying to pull off all the parts from the invoice, you will need to modify the EVAL statement to work with multivalued fields. SELECT INVOICE SAVING UNIQUE EVAL MFG:PART LIST PARTS DESC LISTPRICE George -Original Message- From: Gordon Glorfield [mailto:[EMAIL PROTECTED] Sent: Thursday, August 12, 2004 2:22 PM To: '[EMAIL PROTECTED]' Subject: RE: [U2] How do we get unique records from Universe file(Table) Even if you do create the previously suggested I-descriptor in the dictionary, you are not going to get a list of order IDs from your select. All you will get is a list of the unique combinations, not the record IDs from which they came. I'm thinking that what you are asking for will require a program be written to come up with the information you are looking for. Gordon J. Glorfield Sr. Applications Developer MAMSI (A UnitedHealth Company) 301-360-8839 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Chauhan, Savita Sent: Thursday, August 12, 2004 1:56 PM To: [EMAIL PROTECTED] Subject: RE: [U2] How do we get unique records from Universe file(Table) Can this (selecting only those order IDs which have unique combination of Mfg.No and Part.No) be done without having to create an intermediate dictionary item? Savita Chauhan, Programmer/Analyst x:1754 Central Texas College. --- Change is the only Constant. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of George Gallen Sent: Thursday, August 12, 2004 10:31 AM To: [EMAIL PROTECTED] Subject: RE: [U2] How do we get unique records from Universe file(Table) You can setup a DICTIONARY ITEM that concatantes both values IE. ED DICT FILE MFGPARTNO MFGPARTNO 001: I 002: MFG.NO:PART.NO 003: 004: combo 005: 20L 006: S Assuming they are both single valued fields: Then SELECT ORDERS SAVING UNIQUE MFGPARTNO George -Original Message- From: Chauhan, Savita [mailto:[EMAIL PROTECTED] Sent: Thursday, August 12, 2004 11:09 AM To: [EMAIL PROTECTED] Subject: RE: [U2] How do we get unique records from Universe file(Table) Can we save a unique combination of more than one fields, instead of just saving the unique @ID ie, SELECT ORDERS SAVING UNIQUE MFG.NO PART.NO Will this save records with unique combination of mfg.no and part.no? Savita. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Pingilley, Ron Sent: Thursday, August 12, 2004 9:46 AM To: '[EMAIL PROTECTED]' Subject: RE: [U2] How do we get unique records from Universe file(Table) tax in advance -- sounds like the US Government! :) If you're doing a SELECT at tcl, try adding SAVING UNIQUE to your statement. Here's an example: SELECT ORDERS WITH ORDER.DATE 8/1 PART.NUMBER ...10456 items selected SELECT INVENTORY SAVING UNIQUE @ID ...395 items selected SAVE.LIST AUG.PARTS 1st step selected the PART.NUMBER field from the ORDERS file, with lots of duplicate part numbers showing up. The 2nd step pared that list down to just unique part numbers. --Ron P. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, August 12, 2004 9:05 AM To: [EMAIL PROTECTED] Subject: [U2] How do we get unique records from Universe file(Table) Hi, Can anybody help me in retriving the unique(distinct) records from Universe file tax in advance regards Reddy --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] How do we get unique records from Universe file(Table)
SELECT . SAVING UNIQUE EVAL @RECORD5:@VM:@RECORD7 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Chauhan, Savita Sent: Thursday, August 12, 2004 10:56 AM To: [EMAIL PROTECTED] Subject: RE: [U2] How do we get unique records from Universe file(Table) Can this (selecting only those order IDs which have unique combination of Mfg.No and Part.No) be done without having to create an intermediate dictionary item? Savita Chauhan, Programmer/Analyst x:1754 Central Texas College. --- Change is the only Constant. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of George Gallen Sent: Thursday, August 12, 2004 10:31 AM To: [EMAIL PROTECTED] Subject: RE: [U2] How do we get unique records from Universe file(Table) You can setup a DICTIONARY ITEM that concatantes both values IE. ED DICT FILE MFGPARTNO MFGPARTNO 001: I 002: MFG.NO:PART.NO 003: 004: combo 005: 20L 006: S Assuming they are both single valued fields: Then SELECT ORDERS SAVING UNIQUE MFGPARTNO George -Original Message- From: Chauhan, Savita [mailto:[EMAIL PROTECTED] Sent: Thursday, August 12, 2004 11:09 AM To: [EMAIL PROTECTED] Subject: RE: [U2] How do we get unique records from Universe file(Table) Can we save a unique combination of more than one fields, instead of just saving the unique @ID ie, SELECT ORDERS SAVING UNIQUE MFG.NO PART.NO Will this save records with unique combination of mfg.no and part.no? Savita. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Pingilley, Ron Sent: Thursday, August 12, 2004 9:46 AM To: '[EMAIL PROTECTED]' Subject: RE: [U2] How do we get unique records from Universe file(Table) tax in advance -- sounds like the US Government! :) If you're doing a SELECT at tcl, try adding SAVING UNIQUE to your statement. Here's an example: SELECT ORDERS WITH ORDER.DATE 8/1 PART.NUMBER ...10456 items selected SELECT INVENTORY SAVING UNIQUE @ID ...395 items selected SAVE.LIST AUG.PARTS 1st step selected the PART.NUMBER field from the ORDERS file, with lots of duplicate part numbers showing up. The 2nd step pared that list down to just unique part numbers. --Ron P. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, August 12, 2004 9:05 AM To: [EMAIL PROTECTED] Subject: [U2] How do we get unique records from Universe file(Table) Hi, Can anybody help me in retriving the unique(distinct) records from Universe file tax in advance regards Reddy --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] How do we get unique records from Universe file(Table)
Are trying to build a key to another file? -Original Message- From: Chauhan, Savita [mailto:[EMAIL PROTECTED] Sent: Thursday, August 12, 2004 11:56 AM To: [EMAIL PROTECTED] Subject: RE: [U2] How do we get unique records from Universe file(Table) Can this (selecting only those order IDs which have unique combination of Mfg.No and Part.No) be done without having to create an intermediate dictionary item? Savita Chauhan, Programmer/Analyst x:1754 Central Texas College. --- Change is the only Constant. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] How do we get unique records from Universe file(Table)
Your syntax does appear correct. Sometimes U2 does odd things when you put the * in some of the commands, like the COPY command. Try another character. If that works, then you'll know that it was the * that messed it up. If you need the * because of the key you're trying to build, then just go ahead and create the dict items suggested by others. You can always delete it when you're done (but should copy it to a personal file in case you ever need it again). Or, just leave it in the file as someone else down the road might need it and they won't have to create one because you put it in there! And just in case you don't already know this, you can get help for any of the unibasic or uniquery commands just by typing in HELP or HELP {command} at the TCL prompt. HTH, aee -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Chauhan, Savita Sent: Thursday, August 12, 2004 12:53 To: [EMAIL PROTECTED] Subject: RE: [U2] How do we get unique records from Universe file(Table) Yes, I am trying to build a key to another file. I tired what some of you suggested. It gives me an error. On : SELECT ORDERS SAVING UNIQUE EVAL MFG.NO:'*':PART.NO It gives me following error: : Illegal attribute name for sort: MFG.NO:'*':PART.NO Btw, my doubts are related to Unidata. I have been working on UniData/UniBasic only for 3 weeks now and I presumed that Universe and Unidata have similar syntax. Excuse me for my ignorance, if it works only for Universe and not for Unidata. Savita Chauhan, Programmer/Analyst x:1754 Central Texas College. --- Change is the only Constant. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Shawn Waldie Sent: Thursday, August 12, 2004 2:24 PM To: [EMAIL PROTECTED] Subject: RE: [U2] How do we get unique records from Universe file(Table) Are trying to build a key to another file? -Original Message- From: Chauhan, Savita [mailto:[EMAIL PROTECTED] Sent: Thursday, August 12, 2004 11:56 AM To: [EMAIL PROTECTED] Subject: RE: [U2] How do we get unique records from Universe file(Table) Can this (selecting only those order IDs which have unique combination of Mfg.No and Part.No) be done without having to create an intermediate dictionary item? Savita Chauhan, Programmer/Analyst x:1754 Central Texas College. --- Change is the only Constant. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] How do we get unique records from Universe file(Table)
What are the attribute numbers in the ORDERS file where the MFG.NO and PART.NO are stored? Let's say it's 4 and 18, respectively. : SELECT ORDERS SAVING UNIQUE EVAL @RECORD4:'*':@RECORD18 should do it. The Illegal attribute name for sort: MFG.NO:'*':PART.NO error message may be saying that you don't have an I-descriptor or D-descriptor in DICT ORDERS named MFG.NO or PART.NO. Using @RECORDnnn will work without having to have an existing I- or D- descriptor in place. Here's what I get in a similar test on my system (Universe): SELECT VENDOR SAVING UNIQUE EVAL @RECORD3:'*':@RECORD4 @RECORD 3 : * : @RECORD 4 1263 record(s) selected to SELECT list #0. SAVE.LIST VEND.TEST 1263 record(s) SAVEd to SELECT list VEND.TEST. --Ron P. -Original Message- From: Chauhan, Savita [mailto:[EMAIL PROTECTED] Sent: Thursday, August 12, 2004 2:53 PM To: [EMAIL PROTECTED] Subject: RE: [U2] How do we get unique records from Universe file(Table) Yes, I am trying to build a key to another file. snip It gives me following error: : Illegal attribute name for sort: MFG.NO:'*':PART.NO snip Savita Chauhan, Programmer/Analyst x:1754 Central Texas College. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] How do we get unique records from Universe file(Table)
That's how to do a unique field, if it's a record which has to be unique, you can fake it by creating an I-Desc using @RECORD, the do the SELECT SAVING UNIQUE as mentioned. Beware, if the records are anything but very small, this is a very bad idea and you should solve it programmatically. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Pingilley, Ron Sent: Thursday, August 12, 2004 10:46 AM To: '[EMAIL PROTECTED]' Subject: RE: [U2] How do we get unique records from Universe file(Table) tax in advance -- sounds like the US Government! :) If you're doing a SELECT at tcl, try adding SAVING UNIQUE to your statement. Here's an example: SELECT ORDERS WITH ORDER.DATE 8/1 PART.NUMBER ...10456 items selected SELECT INVENTORY SAVING UNIQUE @ID ...395 items selected SAVE.LIST AUG.PARTS 1st step selected the PART.NUMBER field from the ORDERS file, with lots of duplicate part numbers showing up. The 2nd step pared that list down to just unique part numbers. --Ron P. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, August 12, 2004 9:05 AM To: [EMAIL PROTECTED] Subject: [U2] How do we get unique records from Universe file(Table) Hi, Can anybody help me in retriving the unique(distinct) records from Universe file tax in advance regards Reddy --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/