MQSeries.net :: View topic

protocol · Posted: Wed Feb 09, 2011 8:22 am Post subject:

All,
We are using WMB v7000.

We have a compute node to update a SQL Server DB. The requirement is that the incoming xml has a repeating structure. I read the first occurrence and insert into the table. If the second or higher occurrences match some of the fields in the first occurrence, we have to update the table.

I have a WHILE loop and do a insert for the first occurence, and a SELECT for the other occurrences to see if an INSERT/UPDATE is required.

Sometimes, what is happening is that, after the first INSERT, when we do a SELECT in the WHILE loop for the second occurence, it doesnt seem to identify the first INSERT. I think it's because the first INSERT did not get committed.
Is my understanding correct?
Reading through this forum, I read somewhere that a PASSTHRU('COMMIT') after the INSERT would help. Is that the right approach?

Thanks in advance!