Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2010

    Unanswered: db2 zos stored procedure compile, autocommit off

    Can someone please share the best way to make a stored procedure get the property as autocommit off during compile/deploy time.
    At systemlevel, autocommit is ON
    AT java connection level, autocommit can be changed, but when compiling a SQL Stored procedure, how to make it off so that stored procedure does not commit changes upon exit and can be called in and external transaction.

  2. #2
    Join Date
    Apr 2007
    The default on the CREATE PROCEDURE statement is COMMIT ON RETURN NO. If the stored proc has already been created with COMMIT ON RETURN YES, run the ALTER PROCEDURE statement to change it.

Tags for this Thread

Posting Permissions

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