George:
In UniData, all SAVEDLISTS items have "000" (or "001", etc) appended to
the end of it. Although one can normally do a "SAVE.LIST MY.LIST" and
expect that the actual item ID in the SAVEDLISTS file to be "MY.LIST000"
this isn't always the case if the list is large. This makes managing a
list directly in UD problematic. :-(
HTH,
Bill
------------------------------------------------------------------------
----- Original Message -----
*From:* [email protected]
*To:* U2 Users List <[email protected]>
*Date:* 5/15/2013 6:43 AM
*Subject:* Re: [U2] select query..
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
