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/

Reply via email to