06-17-2009 6:19 AM
I want to execute two insert , however, I want the two statement either to fail or finish together. could you please tell me how to write transaction related statements?
Can you give me an example how to write commit work / rollback for this issue?
Best regards,
Anders
06-17-2009 6:24 AM
06-17-2009 6:21 AM
I never used it but I heard of some concept called Parallel processing which could do it.
06-17-2009 6:23 AM
Then how can you make two OpenSql success together or fail together?
Best regards,
06-17-2009 6:27 AM
U might have to [search>>>|https://forums.sdn.sap.com/search.jspa?q=Parallel%20Processing&dateRange=last90days&searchID=27538411&rankBy=10001&start=0] and do some R&D
06-17-2009 6:24 AM
06-17-2009 6:40 AM
u can use ON COMMIT for subroutines or In UPDATASK.
check keyword documentattion for more info.
ref: link ref'ed by Mahesh.
regards
Prabhu
Edited by: Prabhu Peram on Jun 17, 2009 1:41 PM