MQSeries.net :: View topic - Question on efficiency on processing massive amounts of data

schroederms · Posted: Fri Jul 31, 2009 4:20 am Post subject:

I have a result set coming back from a database that has close to 1 million ids. I'm building a message for each occurance. I'm now trying to use a reference approach which hopefully will keep the pointer in that location, so the next time through in the loop it is not starting at the top of the Environment.Data.GetNameAddr. I know the code below is not correct in bold, but how do you code the next occurance on a reference of a occuring item?

Thanks,
-Mike

if i = 1 then
Set OutputRoot.XMLNSC.REQUEST.APP.USER.FIS_ID = cast(Environment.Data.GetNameAddr[i].A as char);
else
Set OutputRoot.XMLNSC.REQUEST.APP.USER.FIS_ID = cast(myRef[i + 1].A as char);
END IF;

if i = 1 then
declare myRef reference to Environment.Data.GetNameAddr[i];
else
Set myRef = Environment.Data.GetNameAddr[i];
end if;
.
.
.
.
.
Propagate;
Return False;