Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2005
    Posts
    9

    Smile Unanswered: How to Handle transaction commit or rollback in DB2 Stored Procedure

    Hi...

    Is there anybody who knows how to handle transaction commit and rollback in Stored procdure? is there any sample for that?

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    You can use COMMIT, ROLLBACK TO SAVEPOINT and ROLLBACK ... These statements are NOT permitted within ATOMIC blocks ...

    On mainframes, you have a COMMIT ON RETURN statement
    On LUW, you can use an UNDO handler(provided the compound stmt is declared as ATOMIC) to rollback changes that were done within the compound statement


    HTH

    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Jan 2005
    Posts
    9

    thanks for replying, do u have a sample for that

    do u have a sample for that? or material that i can read.

    Thanks again

  4. #4
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Last edited by sathyaram_s; 02-23-05 at 15:55.
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •