Well, in that case you will have to convert the VMs first to something
else like suggested in other posts.
CONVERT or SWAP are fast even on large arrays.
I've actually never tried SELECT and READNEXT with multi-valued
attributes before.
And isn't there another syntax of the REMOVE command like IN.LINE =
REMOVE(IN.TABLE,1,0,0) that would return a multi-valued array?
Mecki
George Gallen wrote:
0001: TESTDYN=""
0002: TESTDYN<-1>="HELLO":CHAR(253):"THERE"
0003: TESTDYN<-1>="UNTIL":CHAR(253):"ANOTHER"
0004: SELECT TESTDYN
0005: LOOP
0006: READNEXT ID ELSE EXIT
0007: PRINT ID
0008: REPEAT
0009: STOP
0010: END
This only returns
HELLO
UNTIL
My first test did not have @vm's and it looked like it worked
but when I put in @vm's, anything after them is ignored.
George
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of
Marvin R. Fisher
Sent: Monday, November 17, 2008 3:00 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Speeding up processing through large dynamic table
But it is not a file - it's an array.
Marvin R. Fisher
Technical Resource Group
A Pipeline Group Company
2850 Red Hill Ave.
Suite 110
Santa Ana, CA 92705
Tel (949) 296-8380 ext. 620
Fax (949) 756-0029
Pipeline Software Statement: This email message is
confidential and may be legally privileged. The contents
contained within, including any attached files, are intended
solely for the addressee(s). Access by anyone other than the
addressee(s) is unauthorized. If you are not the intended
recipient, any disclosure, copying, distribution or any
action, taken or not taken, in reliance on it, is prohibited
and may be unlawful. If you believe that you have received
this email message in error, please contact the sender. Any
views expressed within are those of the individual sender,
except where the sender specifies and with authority, states
them to be the views of Pipeline-Software, Inc., Santa Ana, CA.
(The contents of this email message have been scanned for the
presence of computer viruses.)
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Mecki Foerthmann
Sent: Monday, November 17, 2008 11:21 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Speeding up processing through large dynamic table
READNEXT could be an option
SELECT IN.TAB
LOOP WHILE READNEXT IN.LINE DO
CUST.NUM=IN.LINE<1,1>
CUST.DESC=IN.LINE<1,2>
REPEAT
this should be lightning-fast regardless how big IN.TAB is.
David Laansma wrote:
Is there a way to speed up spinning through a very large dynamic table? Here is
a sample of my program:
A11 = DCOUNT(IN.TAB,@AM)
FOR A1 = 1 TO A11
IN.LINE = IN.TAB<A1>
SWAP @VM WITH @AM IN IN.LINE
CUST.NUM = IN.LINE<1>
CUST.DESC = IN.LINE<2>
NEXT A1
A11 is 85,000+ and as this loop goes on, this thing get really slow. Any tips
on speeding this up?
-------
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
-------
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
-------
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
-------
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
-------
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
