Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.0 » Context-Sensitive Help » Interactive SQL help » Interactive SQL windows


Options window: General tab

This tab has the following components:

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. See echo option [Interactive SQL].

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.

  • 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   When the fast launcher is turned on, Interactive SQL will remain in memory for a configurable length of time after you close it (default is 30 minutes). If you restart Interactive SQL within this time, it will start quickly. If you do not restart Interactive SQL within this time, the process will terminate and will release its resources to the operating system.

Note that the fast launcher process requires additional 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 window where you can configure the TCP/IP port used by the fast launcher and set the inactivity timer.

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.

See also