![ON_TSQL_ERROR option [TSQL]](arrow-right.gif){kind=icon}
Controls what happens if an error is encountered while executing statements in Interactive SQL.
String. See Description 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 he or she wants to continue.
CONTINUE – The error displays and DBISQL continues executing statements.
EXIT – DBISQL 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.
