Mmmm, interesting : This Works! SELECT DISTINCT CODE FROM UNNEST LOOKUP.TABLE ON CODE WHERE @ID = "XYZ" ORDER BY CODE;
Code AAA BBB CCC Is there a way to suppress the Heading? Cheers, S >-----Original Message----- >From: [EMAIL PROTECTED] [mailto:owner-u2- >[EMAIL PROTECTED] 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}BBB}CCC}AAA}AAA}BBB > >>SELECT LOOKUP.TABLE "XYZ" > >1 record(s) selected to SELECT list #0. >>>SELECT CODE FROM UNNEST LOOKUP.TABLE ON CODE SLIST 0 ORDER BY >CODE; >CODE... > >AAA >AAA >AAA >BBB >BBB >BBB >CCC > > >>SELECT LOOKUP.TABLE "XYZ" TO 1 > >1 record(s) selected to SELECT list #1. >>>SELECT CODE SLIST 0 FROM UNNEST LOOKUP.TABLE ON CODE SLIST 1 ORDER >BY CODE; > >7 record(s) selected to SELECT list #0. >>SAVE.LIST XYZ >7 record(s) SAVEd to SELECT list "XYZ". >>EDIT.LIST XYZ >7 lines long. > >----: P >0001: AAA >0002: AAA >0003: AAA >0004: BBB >0005: BBB >0006: BBB >0007: CCC >Bottom at line 7. >----: Q >> > > > >Regards, >David > > > >-----Original Message----- >From: [EMAIL PROTECTED] [mailto:owner-u2- >[EMAIL PROTECTED] On Behalf Of Boydell, Stuart >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\ 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 valid >with UNIQUE keyword. Ignoring SORT options." > >Cheers, >Stuart >------- >u2-users mailing list >u2-users@listserver.u2ug.org >To unsubscribe please visit http://listserver.u2ug.org/ ********************************************************************** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this communication in error, please reply to this e-mail to notify the sender of its incorrect delivery and then delete it and your reply. It is your responsibility to check this email and any attachments for viruses and defects before opening or sending them on. Spotless collects information about you to provide and market our services. For information about use, disclosure and access, see our privacy policy at http://www.spotless.com.au Please consider our environment before printing this email. ********************************************************************** ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/