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