Syntax options:
SQLOPTIONS= (QUIET_COMMIT)
SQLOPTIONS= (NOQUIET_COMMIT)
QUIET COMMIT disables error reporting for the COMMIT and ROLLBACK
statements if either statement is executed when no transaction is
active.
By default, if there is no active transaction, SQL will raise
an error when COMMIT or ROLLBACK is executed. This default,
(NOQUIET_COMMIT), is retained for backward compatibility for
applications that wish to detect the situation. If QUIET_COMMIT
is specified, a COMMIT or ROLLBACK executes successfully when
there is no active transaction.
NOTE
Within a compound statement, the COMMIT and ROLLBACK
statements are always ignored if no transaction is active.