Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

call transaction

Former Member
0 Likes
336

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

1 ACCEPTED SOLUTION
Read only

Jelena_Perfiljeva
Active Contributor
0 Likes
321

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.

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

1 REPLY 1
Read only

Jelena_Perfiljeva
Active Contributor
0 Likes
322

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.