2008 Apr 17 10:18 AM
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
2008 Apr 17 8:47 PM
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
2008 Apr 17 8:47 PM
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.
| User | Count |
|---|---|
| 3 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |