[U2] select query..

2013-05-15 Thread Sathya
Hi Experts.. I have one issue here with fetching data from the file. EXECLINE = SELECT FILE.NAME WITH @ID = \:KEYVALUE:\ DISPLAY EXECLINE EXECUTE EXECLINE RTNLIST LIST1 EXECUTE 'SAVE-LIST SOME.LIST' PASSLIST LIST1 LIST.NAME = GET-LIST SOME.LIST sellist = '' EXECUTE LIST.NAME RTNLIST sellist

Re: [U2] select query..

2013-05-15 Thread Manu Fernandes
d'origine- De : u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] De la part de Sathya Envoyé : mercredi 15 mai 2013 11:45 À : u2-users@listserver.u2ug.org Objet : [U2] select query.. Hi Experts.. I have one issue here with fetching data from the file

Re: [U2] select query..

2013-05-15 Thread Sathya
Manu Fernandes efv at infodata.lu writes: Hi Do you have wildcard characters like [] into KEYVALUE ? If not, why do you SELECT ; it's the key of file.name ; you can read directly ! Elsewhere, For performance, set a index on the at id Why do you want to use save-list/get-list ?

Re: [U2] select query..

2013-05-15 Thread Tom Whitmore
Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Sathya Sent: Wednesday, May 15, 2013 7:19 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] select query.. Manu Fernandes efv at infodata.lu writes: Hi

Re: [U2] select query..

2013-05-15 Thread Mecki Foerthmann
What do you actually try to achieve? On 15/05/2013 12:18, Sathya wrote: Manu Fernandes efv at infodata.lu writes: Hi Do you have wildcard characters like [] into KEYVALUE ? If not, why do you SELECT ; it's the key of file.name ; you can read directly ! Elsewhere, For performance, set a

Re: [U2] select query..

2013-05-15 Thread Sathya
Mecki Foerthmann meckif at gmx.net writes: ___ U2-Users mailing list U2-Users at listserver.u2ug.org Actually Im fetching the KEYVALUE data from a flat file and passing the values one by one to the select command and creating the list. Then

Re: [U2] select query..

2013-05-15 Thread Mecki Foerthmann
So you don't need to select at all. Just use READ record FROM FILE.NAME,KEYVALUE ELSE record = '' in your loop. On 15/05/2013 12:52, Sathya wrote: Mecki Foerthmann meckif at gmx.net writes: ___ U2-Users mailing list U2-Users at listserver.u2ug.org

Re: [U2] select query..

2013-05-15 Thread Israel, John R.
AM To: u2-users@listserver.u2ug.org Subject: [U2] select query.. Hi Experts.. I have one issue here with fetching data from the file. EXECLINE = SELECT FILE.NAME WITH @ID = \:KEYVALUE:\ DISPLAY EXECLINE EXECUTE EXECLINE RTNLIST LIST1 EXECUTE 'SAVE-LIST SOME.LIST' PASSLIST LIST1 LIST.NAME = GET

Re: [U2] select query..

2013-05-15 Thread Wjhonson
BASIC READ -Original Message- From: Israel, John R. johnisr...@daytonsuperior.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Wed, May 15, 2013 5:12 am Subject: Re: [U2] select query.. You should not need to do the SAVE-LIST and GET-LIST unless you wish to do a 2nd

Re: [U2] select query..

2013-05-15 Thread George Gallen
@listserver.u2ug.org Subject: [U2] select query.. Hi Experts.. I have one issue here with fetching data from the file. EXECLINE = SELECT FILE.NAME WITH @ID = \:KEYVALUE:\ DISPLAY EXECLINE EXECUTE EXECLINE RTNLIST LIST1 EXECUTE 'SAVE-LIST SOME.LIST' PASSLIST LIST1 LIST.NAME = GET-LIST SOME.LIST sellist

Re: [U2] select query..

2013-05-15 Thread Bill Haskett
directly in UD problematic. :-( HTH, Bill - Original Message - *From:* ggal...@wyanokegroup.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 5/15/2013 6:43 AM *Subject:* Re: [U2] select query.. I'm

Re: [U2] select query..

2013-05-15 Thread Colin Alfke
there. However, the select shouldn't be taking that long. Hth Colin -Original Message- From: Bill Haskett Sent: Wednesday, May 15, 2013 9:41 AM To: U2 Users List Subject: Re: [U2] select query.. George: In UniData, all SAVEDLISTS items have 000 (or 001, etc) appended to the end of it. Although

Re: [U2] select query..

2013-05-15 Thread Wols Lists
On 15/05/13 18:43, Colin Alfke wrote: That's what READLIST and WRITELIST are for. I've found writing the list as MY.LIST000 to be relatively safe, when you read you would have to check for MY.LIST000, then MY.LIST001, etc. Sathya - as Mecki said, if you're using the @ID of the file you can

Re: [U2] select query..

2013-05-15 Thread Manu Fernandes
:19 À : u2-users@listserver.u2ug.org Objet : Re: [U2] select query.. Manu Fernandes efv at infodata.lu writes: Hi Do you have wildcard characters like [] into KEYVALUE ? If not, why do you SELECT ; it's the key of file.name ; you can read directly ! Elsewhere, For performance

Re: [U2] select query..

2013-05-15 Thread Manu Fernandes
Erratum, LOOP WHILE READNEXT KEYVALUE FROM LIST1 DO -Message d'origine- De : u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] De la part de Manu Fernandes Envoyé : mercredi 15 mai 2013 21:10 À : U2 Users List Objet : Re: [U2] select query.. Hi

Re: [U2] select query..

2013-05-15 Thread Kate Stanton
To speed it up, try resizing the file. On 15 May 2013 21:44, Sathya sathya8...@gmail.com wrote: Hi Experts.. I have one issue here with fetching data from the file. EXECLINE = SELECT FILE.NAME WITH @ID = \:KEYVALUE:\ DISPLAY EXECLINE EXECUTE EXECLINE RTNLIST LIST1 EXECUTE 'SAVE-LIST