topic call transaction in Application Development and Automation Discussions

call transaction

Former Member — Thu, 17 Apr 2008 09:18:26 GMT

hi friends.

im facing problem with call transaction.

Suppose i m having 10 records.

if any 4 of 10 records are error records it should not update database.

only if 10 out of 10 records are correct then it should update database.

please give suggestions

Re: call transaction

Jelena_Perfiljeva — Thu, 17 Apr 2008 19:47:35 GMT

You cannot do this with CALL TRANSACTION command because it updates the database every time you do a CALL. That's why it's called "transaction", actually. For you one transaction = 10 documents, therefore you need to find another way to commit the updates only after all 10 documents (or whatever it is) have been processed correctly.

Search for COMMIT WORK and LUW.