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/
