DB2 Version 10.1 for Linux, UNIX, and Windows

RELEASE option in ROLLBACK statements and COMMIT statements

You can specify the ROLLBACK or COMMIT operation with the connection reset operation in a single statement, when you set the precompiler option COMPATIBILITY_MODE to ORA.

Whenever a new RELEASE option is used, an application must reestablish the connection before any statement is issued on the same connection.

The following example resets connection for ROLLBACK option:

   EXEC SQL ROLLBACK RELEASE;
   EXEC SQL ROLLBACK WORK RELEASE;

The following example resets connection for COMMIT option:

   EXEC SQL COMMIT RELEASE;
   EXEC SQL COMMIT WORK RELEASE;

Remember: The PRECOMPILE command returns the SQL1696N error if you use the new syntax without setting the COMPATIBILITY_MODE parameter to ORA.