ASA Database Administration Guide
  Database Options
    Alphabetical list of options

ON_TSQL_ERROR option [compatibility]

Function 

Controls error-handling in stored procedures.

Allowed values 

String. See below for allowed values.

Default 

CONDITIONAL

See also 

CREATE PROCEDURE statement

CREATE PROCEDURE statement [T-SQL]

Transact-SQL procedure language overview

Description 

This option controls error handling in stored procedures.

• STOP    Stop execution immediately upon finding an error.

• CONDITIONAL    If the procedure uses ON EXCEPTION RESUME, and the statement following the error handles the error, continue, otherwise exit.

• CONTINUE    Continue execution, regardless of the following statement. If there are multiple errors, the first error encountered in the stored procedure is returned.

Both CONDITIONAL and CONTINUE settings for On_TSQL_Error are used for Adaptive Server Enterprise compatibility, with CONTINUE most closely simulating ASE behavior. The CONDITIONAL setting is recommended, particularly when developing new Transact-SQL stored procedures, as it allows errors to be reported earlier.

When this option is set to STOP or CONTINUE, it supercedes the setting of the CONTINUE_AFTER_RAISERROR option. However, when this option is set to CONDITIONAL (the default), behavior following a RAISERROR statement is determined by the setting of the CONTINUE_AFTER_RAISERROR option.