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