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 "@RECORD<4>:'*':@RECORD<18>" 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 @RECORD<nnn> 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 "@RECORD<3>:'*':@RECORD<4>" @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/
