On UD, EVAL only works in ECLTYPE "U". In case you're set to ECLTYPE "P", try your
query again with "select" in lower case. Lower case commands toggle UD to ECLTYPE "U"
on a command-by-command basis.
HTH,
Tom
>>> [EMAIL PROTECTED] 08/12/04 5:10 PM >>>
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.
<snip>
Savita Chauhan,
Programmer/Analyst
x:1754 Central Texas College.
<snip>
-----------------------------------------
This e-mail and any attachments may contain CONFIDENTIAL information, including
PROTECTED HEALTH INFORMATION. If you are not the intended recipient, any use or
disclosure of this information is STRICTLY PROHIBITED; you are requested to delete
this e-mail and any attachments, notify the sender immediately, and notify the LabCorp
Privacy Officer at [EMAIL PROTECTED] or call (877) 23-HIPAA / (877) 234-4722.
-------
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/
