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 <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 ? > 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 <at> 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 <at> 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