ASA Database Administration Guide
  Database Options
    Alphabetical list of options

ON_ERROR option [ISQL]

Function 

Controls what happens if an error is encountered while reading statements from a command file.

Allowed values 

String. See below for allowed values.

Default 

PROMPT

Description 

Controls what happens if an error is encountered while reading statements from a command file, as follows:

• STOP    Interactive SQL stops reading statements from the file and returns to the SQL Statements pane for input.

• PROMPT    Interactive SQL prompts the user to see if the user wishes to continue.

• 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 appears in a message box with a single button. Execution continues once the button is clicked.

• NOTIFY_STOP    The error appears in a message box with a single button. Execution of the script stops once the button is clicked.

• NOTIFY_EXIT    The error appears in a message box with a single button. Interactive SQL terminates once the button is clicked.