Chapter 5 Database Options
201
♦
CONTINUE The error is ignored and Interactive SQL continues
reading statements from the command file. The INPUT statement
continues with the next row, skipping the row that caused the error.
♦
EXIT Interactive SQL terminates.
♦
NOTIFY_CONTINUE The error is displayed in a message box with a
single button. Execution continues once the button is clicked.
♦
NOTIFY_STOP The error is displayed in a message box with a single
button. Execution of the script stops once the button is clicked.
♦
NOTIFY_EXIT The error is displayed in a message box with a single
button. Interactive SQL terminates once the button is clicked.
ON_TSQL_ERROR option
Controls error-handling in stored procedures.
String. See below for allowed values.
CONDITIONAL
"CREATE PROCEDURE statement" on page 453
"CREATE PROCEDURE statement" on page 460
"Transact-SQL procedure language overview" on page 980 of the book ASA
User’s Guide
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. This option most closely mirrors Adaptive Server
Enterprise behavior.
This option deprecates CONTINUE_AFTER_RAISERROR as a way of
simulating Adaptive Server Enterprise behavior for stored procedures.
OPTIMIZATION_GOAL option
Determines whether query processing is optimized towards returning the first
row quickly, or minimizing the cost of returning the complete result set.
Function
Allowed values
Default
See also
Description
Function
To Next Page
Loading...