Contents Index ON_ERROR option [ISQL] OPTIMISTIC_WAIT_FOR_COMMIT

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.

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.


Contents Index ON_ERROR option [ISQL] OPTIMISTIC_WAIT_FOR_COMMIT