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 functiona
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/
ver use
PI/OPEN 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
>
&g
elected 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
: u2-users@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 yo
don't know what to do then. Hope
this
helps.
Bill
>-Original Message-
>From: [EMAIL PROTECTED]
>[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
users@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 mailin
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
Stuart,
Could also use :-
SELECT DISTINCT CODE TO SLIST 0 FROM LOOKUP.TABLE_CODE;
providing CODE is defined as multi-valued
hth
Andy
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Boydell, Stuart
Sent: 23 January 2008 06:57
To: u2-users@listserver.u2ug.
] On Behalf Of Hona, 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
Stuart,
You can do:-
SELECT LOOKUP.TABLE "XYZ" SAVING CODE
MERGE.LIST 0 UNION 0
MERGE.LIST is very fast even on large lists, removes duplicates and the
resultant list is sorted.
HTH
Andy
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Boydell, Stuart
Se
: u2-users@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-
to:[EMAIL PROTECTED] 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
tuart
Sent: Wednesday, January 23, 2008 7:29 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] [UV] Selection help
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\ C
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:[EMAIL PROTECTED] On Behalf Of
>Boydell, S
-
From: 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:[EMAI
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
-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,
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
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
T
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
22 matches
Mail list logo