Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

on_error option [Interactive SQL]

Controls what happens if an error is encountered while executing statements in Interactive SQL.

String (see below for allowed values)

Prompt

Controls what happens if an error is encountered while executing statements, as follows:

• Stop    Interactive SQL stops executing statements.

• Prompt    Interactive SQL prompts the user to see if the user wants to continue.

• Continue    The error is ignored and Interactive SQL continues executing statements.

• Exit    Interactive SQL terminates.

• Notify_Continue    The error is reporting, and the user is prompted to press Enter or click OK to continue.

• Notify_Stop    The error is reported and the user is prompted to press Enter or click OK to stop executing statements.

• Notify_Exit    The error is reported and the user is prompted to press Enter or click OK to terminate Interactive SQL.

When you are executing a .sql file, the values Stop and Exit are equivalent. If you specify either of these values, Interactive SQL terminates.

• SET OPTION statement [Interactive SQL]