![Clarification on Selective Backups [CR #630990]](arrow-left.gif){kind=icon}
The ON_ERROR option was deprecated in Sybase IQ 15.0, but reinstated in Sybase IQ 15.1.
Table 2-4 “DBISQL options” in the Sybase IQ 15.1 and Sybase IQ 15.2 documentation states that ON_ERROR is not currently supported by Sybase IQ. This is incorrect.
“Alphabetical list of options” should include this section:
Controls what happens if an error is encountered while executing statements in Interactive SQL (dbisql).
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.
