Controls the action taken if an error is encountered while executing statements in Interactive SQL.
Controls the action taken, if an error is encountered while executing statements:
STOP – Interactive SQL stops executing statements from the file and returns to the statement window for input.
PROMPT – Interactive SQL prompts the user to see if he or she wants to continue.
CONTINUE – Errors display in the Messages pane and Interactive SQL continues executing statements.
EXIT – Interactive SQL terminates.
NOTIFY_CONTINUE – The error is reported, 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.