What do you actually try to achieve?
On 15/05/2013 12:18, Sathya wrote:
Manu Fernandes <efv <at> infodata.lu> writes:
Hi
Do you have wildcard characters like [] into KEYVALUE ?
If not, why do you SELECT ; it's the key of file.name ; you can read
directly !
Elsewhere, For performance, set a index on the <at> id
Why do you want to use save-list/get-list ?
You can work on LIST1 directly !
manu
Hi Fernandes,
Thanks for your comments. But as Im new to this technology Im not sure how
to proceed with your suggestions.
Can u please be more specific on this approach?
There is no [] symbols in the KEYVALUE. How do I check whether @ID is
indexed?
I will modify it with using LIST1 directly.
Thanks & Regards,
Sathya V.
Hi Experts..
I have one issue here with fetching data from the file.
EXECLINE = "SELECT FILE.NAME WITH <at> 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.
_______________________________________________
://listserver.u2ug.org/mailman/listinfo/u2-users
_______________________________________________
U2-Users mailing list
U2-Users <at> listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
