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.
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;