The General page of the Options window has these components:
Command files These options control Interactive SQL behavior while it is running command files.
When an error occurs Select one of the following options to control how Interactive SQL responds when it encounters an error while executing statements:
Stop – Interactive SQL stops executing statements.
Prompt – Interactive SQL prompts the user whether to continue. This is the default.
Continue – the error is ignored and Interactive SQL continues executing statements.
Exit – interactive SQL shuts down.
Notify and continue – the error is reported, and the user is prompted to press Enter or click OK to continue.
Notify and stop – the error is reported and the user is prompted to press Enter or click OK to stop executing statements.
Notify and exit – the error is reported and the user is prompted to press Enter or click OK to shut down Interactive SQL.
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.
Echo command files to log Select this option to log executed SQL statements to the log file. You may find this option to be useful when you use the READ statement to execute an Interactive SQL command file or when you run a command file in Interactive SQL by choosing File > Run Script. Logging must be turned on for this option to take effect. By default, command files are copied to the log.
Folders Use these options to specify which directory Interactive SQL uses first when browsing for files.
