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: [email protected] [mailto:[email protected]] On Behalf Of Sathya Sent: Wednesday, May 15, 2013 5:45 AM To: [email protected] 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 [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
