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 DBISQL stops executing statements from the file and returns to the statement window for input.
PROMPT DBISQL prompts the user to see if the user wishes to continue.
CONTINUE The error is displayed and DBISQL continues executing statements.
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.