The Commands tab of the Options dialog has the following components:
Commit The following options let you select when to commit changes to the database. You can also commit manually by entering an explicit COMMIT command whenever appropriate.
After each command Select this option to commit changes to the database after each SQL statement is executed.
On exit Select this option to commit changes to the database when you exit your Interactive SQL session. This is the default setting.
For more information, see “AUTO_COMMIT option [DBISQL]” in Chapter 2, “Database Options” in the Sybase IQ Reference Manual.
Command files The following options control Interactive SQL's behavior when running command files.
When an error occurs Select an option to control how Interactive SQL responds when it encounters an error while executing statements from a command file. Depending on the option you choose, Interactive SQL can continue executing the file, stop executing the file, or shut down. The default setting is PROMPT.
For more information about configuring how Interactive SQL responds to errors while executing statements from a command file, see the ON_ERROR option in Chapter 2, “Database Options” in the Sybase IQ Reference Manual.
Echo command files to log If you select this option, Interactive SQL logs SQL statements that are executed from command files to the log file.
By default, command files are copied to the log.
For more information, see the ECHO option in Chapter 2, “Database Options” in the Sybase IQ Reference Manual.
When browsing for files, where should the browser start? Select one of the following options to specify which directory Interactive SQL uses first when browsing for files. If you wish to use this setting in subsequent Interactive SQL sessions, click Make Permanent after selecting one of the following options.
File association On Windows platforms, you can make Interactive SQL the default editor for .sql files.
