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. <[email protected]> To: U2 Users List <[email protected]> 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: [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 _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
