HELPLIB.HLB  —  SQLPRE72  SQLPRE Command Line, Arguments  QUIET_COMMIT___NOQUIET_COMMIT
 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.
Close Help