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 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 SOME.LIST' P

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..

2013-05-15 Thread Manu Fernandes
.u2ug.org [mailto:u2-users- > boun...@listserver.u2ug.org] De la part de Sathya > Envoyé : mercredi 15 mai 2013 13:19 > À : u2-users@listserver.u2ug.org > Objet : Re: [U2] select query.. > > Manu Fernandes infodata.lu> writes: > > > > > > Hi > &

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

Re: [U2] select query..

2013-05-15 Thread Colin Alfke
e you can do a straight read to check if it's 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 item

Re: [U2] select query..

2013-05-15 Thread Bill Haskett
se if the list is large. This makes managing a list directly in UD problematic. :-( HTH, Bill - Original Message - *From:* ggal...@wyanokegroup.com *To:* U2 Users List *Date:* 5/15/2013 6:43 AM *Subject:* Re:

Re: [U2] select query..

2013-05-15 Thread George Gallen
13 5:45 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&

Re: [U2] select query..

2013-05-15 Thread Wjhonson
BASIC READ -Original Message- From: Israel, John R. To: U2 Users List 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 pass on the exact same results. The main purpose of a

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&#

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 gmx.net> writes: ___ U2-Users mailing list U2-Users listserver.u2ug.org Actually

Re: [U2] select query..

2013-05-15 Thread Sathya
Mecki Foerthmann gmx.net> writes: > > > > ___ > U2-Users mailing list > U2-Users 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 I wil

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 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 o

Re: [U2] select query..

2013-05-15 Thread Tom Whitmore
ME RTNLIST sellist CAPTURING junk Tom Whitmore RATEX Business 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]

Re: [U2] select query..

2013-05-15 Thread Sathya
Manu Fernandes 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 id > > Why do you want to use save-list/get-list ? >

Re: [U2] select query..

2013-05-15 Thread Manu Fernandes
-Message 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 on

[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 selli