SQL Anywhere Studio Help
Interactive SQL Help
Options dialog
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 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 [ISQL].
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 ON_ERROR option [ISQL].
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 ECHO option [ISQL].
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 platforms.
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.
Configure Opens the DBISQL 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 machine. 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 platforms, you can make Interactive SQL the default editor for .SQL files.
Make DBISQL the default editor for .SQL files Select this option to make Interactive SQL the default editor for .SQL files on Windows.
Windows uses Interactive SQL to automatically open the file when you double-click on it. Note that Interactive SQL does not run the file automatically.
SET OPTION statement [Interactive SQL]