Try
select VENF16 72988359 SAVING F21
-Original Message-
From: Bill Haskett [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 23, 2008 1:46 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] [UV] Selection help
Thanks Andy. I didn't know about this added functionality of QSELECT
How about using SQL?
SELECT DISTINCT CODE TO SLIST 0 FROM UNNEST filename ON CODE;
(Sorry, don't have the original post open, can't remember the file name.)
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
Thanks but it didn't work.
-Original Message-
Try
SELECT LOOKUP.TABLE XYZ SAVING UNIQUE EVAL RAISE(CODE)
**
This email message and any files transmitted with it are confidential and
intended solely for the use of
-users@listserver.u2ug.org
Subject: RE: [U2] [UV] Selection help
Try
SELECT LOOKUP.TABLE XYZ SAVING UNIQUE EVAL RAISE(CODE)
Regards,
David
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Boydell, Stuart
Sent: Wednesday, January 23, 2008 5:57 PM
To: u2-users
Thanks to everyone, it's a bit less straightforward but I have got it
working by passing the list through the unix shell.
'SH -c ':uv 'LIST LOOKUP.TABLE \XYZ\ CODE ID.SUP COL.HDR.SUPP
COUNT.SUP'|sort -u|tail +3:''
Nb. If I use a BY.EXP ... SAVING UNIQUE I get the warning: SORT
criteria not
Oops sorry, I didn't read your issue properly!
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Boydell, Stuart
Sent: Wednesday, January 23, 2008 7:00 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] [UV] Selection help
Thanks but it didn't work
: Andrew Lakeland
Sent: 23 January 2008 08:44
To: 'u2-users@listserver.u2ug.org'
Subject: RE: [U2] [UV] Selection help
I Always explode it.
SELECT LOOKUP.TABLE XYZ BY.EXP CODE SAVING UNIQUE CODE
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Hona, David S
Sent: Wednesday, January 23, 2008 5:57 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] [UV] Selection help
I have a table which contains an MV list of codes. What I want to do is
get a unique list of codes in the table for a lookup list...
Table XYZ
@ID = XYZ
LINE = 1]2]3]4]5]6]7...
CODE = AAA
] On Behalf Of Hona, David S
Sent: 23 January 2008 09:06
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] [UV] Selection help
Okay, had a rethink now...how about UV/SQL...? ;)
CT LOOKUP.TABLE XYZ
XYZ
0001 1}2}3}4}5}6}7
0002 AAA}BBB}BBB}CCC}AAA}AAA}BBB
SELECT LOOKUP.TABLE XYZ
1
@listserver.u2ug.org
Subject: RE: [U2] [UV] Selection help
Doesn't UV have something like BSELECT? So the commands would be:
:BSELECT LOOKUP.TABLE XYZ CODE
{n} records selected to list 0.
:SELECT SomeFile SAVING UNIQUE @ID
Just a thought.
Bill
-Original Message-
From: [EMAIL PROTECTED]
[mailto
Sent: 23 January 2008 06:57
To: u2-users@listserver.u2ug.org
Subject: [U2] [UV] Selection help
I have a table which contains an MV list of codes. What I want to do is
get a unique list of codes in the table for a lookup list...
Table XYZ
@ID = XYZ
LINE = 1]2]3]4]5]6]7...
CODE = AAA]BBB]BBB]CCC]AAA
, David S
Sent: Wednesday, 23 January 2008 20:06
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] [UV] Selection help
Okay, had a rethink now...how about UV/SQL...? ;)
CT LOOKUP.TABLE XYZ
XYZ
0001 1}2}3}4}5}6}7
0002 AAA}BBB}BBB}CCC}AAA}AAA}BBB
SELECT LOOKUP.TABLE XYZ
1 record(s) selected
@listserver.u2ug.org
Subject: [U2] [UV] Selection help
I have a table which contains an MV list of codes. What I want to do is
get a unique list of codes in the table for a lookup list...
Table XYZ
@ID = XYZ
LINE = 1]2]3]4]5]6]7...
CODE = AAA]BBB]BBB]CCC]AAA]AAA]BBB...
The list I'd like returned is: AAA]BBB]CCC
Stuart have you tried SQL? Off the top of my head:
SELECT DISTINCT CODE TO SLIST 0 FROM LOOKUP.TABLE WHERE @ID = XYZ;
eg:
(If you create the F7 dict entry for the VOC)
03 SELECT DISTINCT F7 TO SLIST 0 FROM VOC WHERE @ID = 'BASIC';
4 record(s) selected to SELECT list #0.
SAVE-LIST CLIST
4
@listserver.u2ug.org
Subject: RE: [U2] [UV] Selection help
David
Very close.. just need the uniqueness adding.
How about simply:
SELECT DISTINCT CODE FROM UNNEST LOOKUP.TABLE ON CODE WHERE @ID = 'XYZ'
ORDER BY CODE;
Code..
AAA
BBB
CCC
3 records listed.
Brian
---
u2-users mailing list
u2-users
]
[mailto:[EMAIL PROTECTED] On Behalf Of
Andrew Lakeland
Sent: Wednesday, January 23, 2008 1:39 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] [UV] Selection help
Think you mean QSELECT.
QSELECT LOOKUP.TABLE XYZ SAVING 10
Select multivlaues in field 10.you still need another
select
@listserver.u2ug.org
Subject: RE: [U2] [UV] Selection help
Andrew:
I believe I meant BSELECT. QSELECT is used to build a list of all
attributes in a
record.
In UniData, to get a select list of the contents of an attribute you
would:
:BSELECT LOOKUP.TABLE XYZ CODE
In D3 you'd simply:
:SELECT
to SELECT list #0.
You can then do additonal select using UNIQUE
Re
andy
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett
Sent: 23 January 2008 13:38
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] [UV] Selection help
Andrew:
I believe I
flavor.
Thanks again,
Bill
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Andrew Lakeland
Sent: Wednesday, January 23, 2008 6:13 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] [UV] Selection help
Hi Bill,
BSELECT does not exist on UV. (which
I have a table which contains an MV list of codes. What I want to do is
get a unique list of codes in the table for a lookup list...
Table XYZ
@ID = XYZ
LINE = 1]2]3]4]5]6]7...
CODE = AAA]BBB]BBB]CCC]AAA]AAA]BBB...
The list I'd like returned is: AAA]BBB]CCC...
The semantic I think I'd like is:
Try
SELECT LOOKUP.TABLE XYZ SAVING UNIQUE EVAL RAISE(CODE)
Regards,
David
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Boydell, Stuart
Sent: Wednesday, January 23, 2008 5:57 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] [UV] Selection help
I
I Always explode it.
SELECT LOOKUP.TABLE XYZ BY.EXP CODE SAVING UNIQUE CODE
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Hona, David S
Sent: 23 January 2008 08:16
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] [UV] Selection help
Try
SELECT
22 matches
Mail list logo