on_error option [Interactive SQL]

Stop Interactive SQL stops executing statements.
Prompt Interactive SQL prompts the user to see if they want to continue.
Continue The error is ignored and Interactive SQL continues executing statements.
Exit Interactive SQL shuts down.
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 shut down Interactive SQL.

Prompt

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

This option is ignored if the Interactive SQL utility (dbisql) onerror option is specified. See Interactive SQL utility (dbisql).