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/
