Mload upsert

Tools & Utilities
Enthusiast

Mload upsert

Hi,

My question here is does Mload process records in the same order
that the records are in the input file?

Assume in the input file, I have the following records. Key is same.
A
B
C

In the Mload upsert process (update otherwise insert), My assumption
is first A record is processed, then B and C. In that case, A will be inserted, B and C are updated since the key is same for all these records.

I think at the end of the acquistion phase, work tables are sorted
before the application phase begins. Will the processing order be different
than the file layout?. I mean, the system may insert B first, then treat
A and C are updates. Please reply.

Thanks
1 REPLY
Enthusiast

Re: Mload upsert

Sorry. The same topic has been posted three times.
That was not my intention. I got the error message when
I was trying to post. I thought it was not posted.
But it is there three times.