Re: [U2] select query..
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' PASSLIST LIST1 > > LIST.NAME = "GET-LIST SOME.LIST" > sellist = '' > EXECUTE LIST.NAME RTNLIST sellist CAPTURING junk > > Here Im running a loop for a set of "KEYVALUE"s and for each run the > SSELECT statement is taking around 30 seconds. When I want to run 1000 > loops, ideally the run time will be much. > > Is there any easier way to do this with less time consumption. > > Thanks & Regards, > Sathya V. > > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > -- Kate Stanton Walstan Systems Ltd 4 Kelmarna Ave, Herne Bay, Auckland 1011, New Zealand Phone: + 64 9 360 5310 Mobile: + 64 21 400 486 Email: k...@walstan.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] select query..
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 Sathya, > > Clearly, in basic, if you know the unique-key of a record, you don't need to > select it to access its data. > > Do it like this : > > OPEN FILE.NAME TO F.FILE.NAME ELSE ... error ... > KEYVALUE = > READ V.RECORD FROM F.FILE.NAME, KEYVALUE THEN > * OK RECORD EXIST ; V.RECORD IS LOADED WITH DATA END ELSE > * KO RECORD DOESN'T EXIST ! V.RECORD IS NOT MODIFIED > V.RECORD = '' > END > > Do what you need with V.RECORD > > -- > > Now if the value you have is not the unique-key ; you need to execute a > select. > Do like this : > OPEN FILE.NAME TO F.FILE.NAME ELSE ... error ... > DATAVALUE =. .. > EXECUTE 'SELECT FILE.NAME WITH FIELD.NAME = "':DATAVALUE:'"' RTNLIST > LIST1 LOOP WHILE READNEXT KEYVALUE DO > READ V.RECORD FROM F.FILE.NAME,KEYVALUE THEN > * OK RECORD EXIST > END ELSE > * KO RECORD DOEN'T EXIST > CONTINUE ;* GOTO NEXT READNEXT > END > Do what you need with V.RECORD > REPEAT > > > By extension, You can create index à "secondary-key" declaration like this : > At TCL,do like this (with users logged out) > >CREATE.INDEX FILE.NAME FIELD.NAME NO.NULLS BUILD.INDEX FILE.NAME > >FIELD.NAME > If exist, Universe "SELECT" use automatically the "index" system > > - > I hope this help. > Manu > > -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 13:19 À : u2-users@listserver.u2ug.org Objet : Re: [U2] > > select query.. > > > > 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 ? > > > You can work on LIST1 directly ! > > > > > > manu > > > > > > Hi Fernandes, > > > > Thanks for your comments. But as Im new to this technology Im not sure > > how to proceed with your suggestions. > > > > Can u please be more specific on this approach? > > > > There is no [] symbols in the KEYVALUE. How do I check whether @ID is > > indexed? > > > > I will modify it with using LIST1 directly. > > > > Thanks & Regards, > > Sathya V. > > > > > > > > > > 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 CAPTURING junk > > > > Here Im running a loop for a set of "KEYVALUE"s and for each run the > > SSELECT statement is taking around 30 seconds. When I want to run 1000 > > loops, ideally the run time will be much. > > > > Is there any easier way to do this with less time consumption. > > > > Thanks & Regards, > > Sathya V. > > > > ___ > > ://listserver.u2ug.org/mailman/listinfo/u2-users > > > > > > ___ > > > U2-Users mailing list > > > U2-Users listserver.u2ug.org > > > http://listserver.u2ug.org/mailman/listinfo/u2-users > > > > > > > > > > > > > > > > ___ > > U2-Users mailing list > > U2-Users@listserver.u2ug.org > > http://listserver.u2ug.org/mailman/listinfo/u2-users > > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] select query..
Hi Sathya, Clearly, in basic, if you know the unique-key of a record, you don't need to select it to access its data. Do it like this : OPEN FILE.NAME TO F.FILE.NAME ELSE ... error ... KEYVALUE = READ V.RECORD FROM F.FILE.NAME, KEYVALUE THEN * OK RECORD EXIST ; V.RECORD IS LOADED WITH DATA END ELSE * KO RECORD DOESN'T EXIST ! V.RECORD IS NOT MODIFIED V.RECORD = '' END Do what you need with V.RECORD -- Now if the value you have is not the unique-key ; you need to execute a select. Do like this : OPEN FILE.NAME TO F.FILE.NAME ELSE ... error ... DATAVALUE =. .. EXECUTE 'SELECT FILE.NAME WITH FIELD.NAME = "':DATAVALUE:'"' RTNLIST LIST1 LOOP WHILE READNEXT KEYVALUE DO READ V.RECORD FROM F.FILE.NAME,KEYVALUE THEN * OK RECORD EXIST END ELSE * KO RECORD DOEN'T EXIST CONTINUE ;* GOTO NEXT READNEXT END Do what you need with V.RECORD REPEAT By extension, You can create index à "secondary-key" declaration like this : At TCL,do like this (with users logged out) >CREATE.INDEX FILE.NAME FIELD.NAME NO.NULLS >BUILD.INDEX FILE.NAME FIELD.NAME If exist, Universe "SELECT" use automatically the "index" system - I hope this help. Manu > -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 13:19 > À : u2-users@listserver.u2ug.org > Objet : Re: [U2] select query.. > > 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 ? > > You can work on LIST1 directly ! > > > > manu > > > Hi Fernandes, > > Thanks for your comments. But as Im new to this technology Im not sure how > to proceed with your suggestions. > > Can u please be more specific on this approach? > > There is no [] symbols in the KEYVALUE. How do I check whether @ID is > indexed? > > I will modify it with using LIST1 directly. > > Thanks & Regards, > Sathya V. > > > > > 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 CAPTURING junk > > Here Im running a loop for a set of "KEYVALUE"s and for each run the > SSELECT > statement is taking around 30 seconds. When I want to run 1000 loops, > ideally > the run time will be much. > > Is there any easier way to do this with less time consumption. > > Thanks & Regards, > Sathya V. > > ___ > ://listserver.u2ug.org/mailman/listinfo/u2-users > > > > ___ > > U2-Users mailing list > > U2-Users listserver.u2ug.org > > http://listserver.u2ug.org/mailman/listinfo/u2-users > > > > > > > > > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] select query..
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 do a > straight read to check if it's there. However, the select shouldn't be > taking that long. The other little trick you can use (I hope, it's fine in UV) is EXECUTE "SELECT FILE.NAME ":KEYVALUE However, I agree with the other posters that you probably shouldn't be using SELECT at all. But you can pass a (list of) keys directly to SELECT without having to specify "equals" or anything like that. Cheers, Wol ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] select query..
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 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 items have "000" (or "001", etc) appended to the end of it. Although one can normally do a "SAVE.LIST MY.LIST" and expect that the actual item ID in the SAVEDLISTS file to be "MY.LIST000" this isn't always the case 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: [U2] select query.. > I'm confused.. > > If your doing a select with @ID = you will only get 1 response each time, > @ID is a primary key field. So as suggested just open the file, then do a read from > That file with the given @ID. > > An alternative to a SAVE.LIST and GET.LIST could be to open "&SAVEDLISTS&" as file > Then READ and WRITE your dynamic list to that file, and just use a FOR/NEXT loop to > Traverse it. > > George > > -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 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' PASSLIST LIST1 > > LIST.NAME = "GET-LIST SOME.LIST" > sellist = '' > EXECUTE LIST.NAME RTNLIST sellist CAPTURING junk > > Here Im running a loop for a set of "KEYVALUE"s and for each run the > SSELECT statement is taking around 30 seconds. When I want to run 1000 > loops, ideally the run time will be much. > > Is there any easier way to do this with less time consumption. > > Thanks & Regards, > Sathya V. > ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] select query..
George: In UniData, all SAVEDLISTS items have "000" (or "001", etc) appended to the end of it. Although one can normally do a "SAVE.LIST MY.LIST" and expect that the actual item ID in the SAVEDLISTS file to be "MY.LIST000" this isn't always the case 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: [U2] select query.. I'm confused.. If your doing a select with @ID = you will only get 1 response each time, @ID is a primary key field. So as suggested just open the file, then do a read from That file with the given @ID. An alternative to a SAVE.LIST and GET.LIST could be to open "&SAVEDLISTS&" as file Then READ and WRITE your dynamic list to that file, and just use a FOR/NEXT loop to Traverse it. George -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 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' PASSLIST LIST1 LIST.NAME = "GET-LIST SOME.LIST" sellist = '' EXECUTE LIST.NAME RTNLIST sellist CAPTURING junk Here Im running a loop for a set of "KEYVALUE"s and for each run the SSELECT statement is taking around 30 seconds. When I want to run 1000 loops, ideally the run time will be much. Is there any easier way to do this with less time consumption. Thanks & Regards, Sathya V. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] select query..
I'm confused.. If your doing a select with @ID = you will only get 1 response each time, @ID is a primary key field. So as suggested just open the file, then do a read from That file with the given @ID. An alternative to a SAVE.LIST and GET.LIST could be to open "&SAVEDLISTS&" as file Then READ and WRITE your dynamic list to that file, and just use a FOR/NEXT loop to Traverse it. George -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 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' PASSLIST LIST1 LIST.NAME = "GET-LIST SOME.LIST" sellist = '' EXECUTE LIST.NAME RTNLIST sellist CAPTURING junk Here Im running a loop for a set of "KEYVALUE"s and for each run the SSELECT statement is taking around 30 seconds. When I want to run 1000 loops, ideally the run time will be much. Is there any easier way to do this with less time consumption. Thanks & Regards, Sathya V. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] select query..
Unlike SQL (Snail Query Language), in Multi Value you do not need to SELECT to return the row of the key itself. MultiValue provides the READ command READ theRow FROM theFile,KeyValue THEN do something And you do not need an EXECUTE wrapping a READ as you would for a SELECT At TCL type HELP 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 SAVEDLIST is to prevent you from having to do the same select multiple times (or to preserve the list of keys for some other purpose). Note that a SAVEDLIST is just a list of KEYs and no other data. I do not understand what is in KEYVALUE. I am assuming you are running in native UniData/UniVerse mode. If you are always wanting the same records, just build a permanent SAVEDLIST, get it and never bother with a SELECT again. A little more info about what you are ultimately trying to accomplish will help us give you a more specific solution. How many values are in KEYVALUE? -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 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' PASSLIST LIST1 LIST.NAME = "GET-LIST SOME.LIST" sellist = '' EXECUTE LIST.NAME RTNLIST sellist CAPTURING junk Here Im running a loop for a set of "KEYVALUE"s and for each run the SSELECT statement is taking around 30 seconds. When I want to run 1000 loops, ideally the run time will be much. Is there any easier way to do this with less time consumption. Thanks & Regards, Sathya V. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
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 SAVEDLIST is to prevent you from having to do the same select multiple times (or to preserve the list of keys for some other purpose). Note that a SAVEDLIST is just a list of KEYs and no other data. I do not understand what is in KEYVALUE. I am assuming you are running in native UniData/UniVerse mode. If you are always wanting the same records, just build a permanent SAVEDLIST, get it and never bother with a SELECT again. A little more info about what you are ultimately trying to accomplish will help us give you a more specific solution. How many values are in KEYVALUE? -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 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' PASSLIST LIST1 LIST.NAME = "GET-LIST SOME.LIST" sellist = '' EXECUTE LIST.NAME RTNLIST sellist CAPTURING junk Here Im running a loop for a set of "KEYVALUE"s and for each run the SSELECT statement is taking around 30 seconds. When I want to run 1000 loops, ideally the run time will be much. Is there any easier way to do this with less time consumption. Thanks & Regards, Sathya V. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] select query..
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 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 will write the data into another log file. http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] select query..
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 will write the data into another log file. > http://listserver.u2ug.org/mailman/listinfo/u2-users > > ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] select query..
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 on the id Why do you want to use save-list/get-list ? You can work on LIST1 directly ! manu Hi Fernandes, Thanks for your comments. But as Im new to this technology Im not sure how to proceed with your suggestions. Can u please be more specific on this approach? There is no [] symbols in the KEYVALUE. How do I check whether @ID is indexed? I will modify it with using LIST1 directly. Thanks & Regards, Sathya V. 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 CAPTURING junk Here Im running a loop for a set of "KEYVALUE"s and for each run the SSELECT statement is taking around 30 seconds. When I want to run 1000 loops, ideally the run time will be much. Is there any easier way to do this with less time consumption. Thanks & Regards, Sathya V. ___ ://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] select query..
Hi, You are better off executing everything in one EXECUTE statement, it is cleaner. EXECLINE='SELECT FILE.NAME WITH @ID = "':KEYVALUE:'"' EXECLINE<-1>='SAVE-LIST SOME.LIST' EXECLINE<-1>='GET-LIST SOME.LIST' EXECUTE LIST.NAME 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] select query.. 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 ? > You can work on LIST1 directly ! > > manu Hi Fernandes, Thanks for your comments. But as Im new to this technology Im not sure how to proceed with your suggestions. Can u please be more specific on this approach? There is no [] symbols in the KEYVALUE. How do I check whether @ID is indexed? I will modify it with using LIST1 directly. Thanks & Regards, Sathya V. 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 CAPTURING junk Here Im running a loop for a set of "KEYVALUE"s and for each run the SSELECT statement is taking around 30 seconds. When I want to run 1000 loops, ideally the run time will be much. Is there any easier way to do this with less time consumption. Thanks & Regards, Sathya V. ___ ://listserver.u2ug.org/mailman/listinfo/u2-users > > ___ > U2-Users mailing list > U2-Users listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > > ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] select query..
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 ? > You can work on LIST1 directly ! > > manu Hi Fernandes, Thanks for your comments. But as Im new to this technology Im not sure how to proceed with your suggestions. Can u please be more specific on this approach? There is no [] symbols in the KEYVALUE. How do I check whether @ID is indexed? I will modify it with using LIST1 directly. Thanks & Regards, Sathya V. 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 CAPTURING junk Here Im running a loop for a set of "KEYVALUE"s and for each run the SSELECT statement is taking around 30 seconds. When I want to run 1000 loops, ideally the run time will be much. Is there any easier way to do this with less time consumption. Thanks & Regards, Sathya V. ___ ://listserver.u2ug.org/mailman/listinfo/u2-users > > ___ > U2-Users mailing list > U2-Users listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > > ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] select query..
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 ? You can work on LIST1 directly ! manu > -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 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 CAPTURING junk > > Here Im running a loop for a set of "KEYVALUE"s and for each run the SSELECT > statement is taking around 30 seconds. When I want to run 1000 loops, ideally > the run time will be much. > > Is there any easier way to do this with less time consumption. > > Thanks & Regards, > Sathya V. > > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[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 = '' EXECUTE LIST.NAME RTNLIST sellist CAPTURING junk Here Im running a loop for a set of "KEYVALUE"s and for each run the SSELECT statement is taking around 30 seconds. When I want to run 1000 loops, ideally the run time will be much. Is there any easier way to do this with less time consumption. Thanks & Regards, Sathya V. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users