|
The General tab of the Options dialog in Interactive SQL 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 statement 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.
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. Depending on the option you choose, Interactive SQL can continue executing, stop executing, 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 on_error option [Interactive SQL].
Echo command files to log If you select this option, Interactive SQL logs SQL statements that are executed to the log file.
By default, command files are copied to the log.
Folders Select one of the following options to specify which directory Interactive SQL uses first when browsing for files.
Last folder used If you select this option, the initial browser directory is the one where you last used the file browser. This is the default setting.
Current folder If you select this option, the initial directory used by the browser is the current folder, as defined by the operating system.
Fast Launcher The fast launcher is designed to reduce Interactive SQL's startup time. When the fast launcher is turned on, the fast launcher process (dbisqlg.exe for Interactive SQL) starts when you log in. The fast launcher is only available on Windows.
Note that the fast launcher process requires a significant amount of memory, and the impact on application startup time depends on your system configuration.
Enable fast launcher Select this option to turn on the fast launcher. The fast launcher is turned on by default. If you want to turn the fast launcher off, clear this checkbox. You must log out and log in again for these settings to take effect.
Configure Opens the Interactive SQL Fast Launcher Configuration dialog where you can configure the TCP/IP port used by the fast launcher and set the inactivity timer.
The fast launcher uses a TCP/IP port on your computer. If another program is already using this port, you can change the port number used by the fast launcher in this dialog. When the fast launcher is not used for the amount of time specified in the inactivity timer, it shuts down, which frees up memory for other applications. By default, the inactivity timer is set to never shut down.File Association On Windows, you can make Interactive SQL the default editor for .sql files.
Make Interactive SQL the default editor for .SQL and plan files Select this option to make Interactive SQL the default editor for .sql and graphical plan files on Windows. SQL Anywhere graphical plan files have the extension .saplan.
If you select this option, Windows uses Interactive SQL to automatically open the file when you double-click it. Note that Interactive SQL does not run the file automatically.