ISQL Options
Go Up to Configuring Feature Options
The ISQL options are available on the following Options Editor tabs:
- ISQL Options - Main Tab
- ISQL Options - Oracle Tab
- ISQL Options - DB2 Tab
- ISQL Options - Sybase Tab
- ISQL Options - SQL Server Tab
- ISQL Options - Sybase IQ Tab
- ISQL Options - MySQL Tab
- ISQL Options - DB2 OS390 Tab
- ISQL Options - Editor Tab
- ISQL Options - Auto format Tab
- ISQL Options - Code Assist Tab
Contents
- 1 ISQL Options - Main Tab
- 2 ISQL Options - Oracle Tab
- 3 ISQL Options - DB2 Tab
- 4 ISQL Options - Sybase Tab
- 5 ISQL Options - Sybase IQ Tab
- 6 ISQL Options - SQL Server Tab
- 7 ISQL Options - MySQL Tab
- 8 ISQL Options - DB2 OS390 Tab
- 9 ISQL Options - Teradata Tab
- 10 ISQL Options - Editor Tab
- 11 ISQL Options - Auto format Tab
- 12 ISQL Options - Code Assist Tab
- 13 ISQL Options - Code Assist - Main Tab
- 14 ISQL Options - Code Assist - Advanced Tab
ISQL Options - Main Tab
The Options Editor’s ISQL tab and its sub-tabs control the appearance and behavior of the SQL Editor.
- Note: For information on opening the Options Editor, see Specifying Application Preferences and Feature Options.
- Note: For information on using the SQL Editor, see Coding Environments/Editors.
Use the following table as a guide to modifying settings on this tab:
Max Errors Before Aborting Execution |
Sets the maximum number of errors allowed before aborting the execution of a script. A zero indicates that the option is inactive and that you recognize no limit to the number of errors allowed. This value is used when step executing SQL scripts. |
Execute Selected Text |
Executes a portion of a selected SQL script. |
Check Syntax When Executing |
For DB2, required to execute DB2 call statements in the ISQL Window. |
Automatically lock connection |
When disabled, a prompt to commit or rollback the transaction is displayed when you close the ISQL editor window. Enabling this options disables the prompts and locks the connection automatically. |
Prompt to lock database connection |
Locks the database connection on execution. |
Tabs |
Sets the appearance of the ISQL Window tabs to either the top or bottom of the ISQL Window. |
File Association |
Specifies whether the application should open an unknown file type automatically into an ISQL Window or prompt you with a message that the file type is not recognized. |
Query Plan Layout |
Sets the default orientation of a graphical query plan. For more information, see Setting up the Execution Environment with Query options. |
ISQL Options - Oracle Tab
The Options Editor’s ISQL > Oracle tab controls the appearance and behavior of the SQL Editor when executing against an Oracle environment.
- Note: For information on opening the Options Editor, see Specifying Application Preferences and Feature Options.
- Note: For information on using the SQL Editor, see Coding Environments/Editors.
Use the following table as a guide to modifying settings on this tab:
Option | Description |
---|---|
Enable DBMS Output |
Lets you specify Buffer size. 0 is the default. |
Auto-Commit changes |
Applies auto commit status changes to all open windows. |
View xmltype as clob |
When enabled, xmltype columns are displayed as CLOBs in the Results grid and the Data editor. Without this option selected, SELECT statements that qualify xmltype columns produce an OciTypeBinder conversion error. With the option selected, the SELECT submitted is modified to include a getclobval() method call. |
Retain connection in pool after use |
This option determines what happens to a connection after it is unlocked by the ISQL window. If selected, the connection will be returned to the application connection pool. If unselected, the unlocked connection will be disconnected. |
Load Query Options |
If this option is not enabled, a set of default query options is loaded that customize your execution environment, and periodically sends those settings to the server. Enabling this option and specifying an XML file, forces load of a previously saved query options file each time an ISQL windows opens against this DBMS platform. This lets you override default query options. You can also enable this option when saving a query options file. For information on other load and save options, specific query options offered, manually updating query options, and conditions for which query options are sent to the server, see Setting up the Execution Environment with Query options. |
Default Query Plan |
Lets you select the default display, whether graphical, tree-based, or DBMS_XPLAN, when you generate a query plan. For more information, see Viewing a Tree-based, Graphical, or DBMS_XPLAN Query Plan (Oracle). |
ISQL Options - DB2 Tab
The Options Editor’s ISQL > DB2 tab controls the appearance and behavior of the SQL Editor when executing against aDB2 LUW environment.
- Note: For information on opening the Options Editor, see Specifying Application Preferences and Feature Options.
- Note: For information on using the SQL Editor, see Coding Environments/Editors.
Use the following table as a guide to modifying settings on this tab:
Option | Description |
---|---|
Set Isolation Level |
Sets the default for the value of the Isolation Level option on the Query Options dialog. For details, see Setting up the Execution Environment with Query options. |
Auto-Commit changes |
Applies auto commit status changes to all open windows. |
Create Explain plan tables if required |
If set to TRUE, Explain Plan tables are created, as necessary. If set to FALSE and you don’t manually create tables, Explain Plan operations will fail. |
Create explain plan tables on the SYSTOOLS schema |
If set to TRUE, Explain Plan tables are created on the SYSTOOLS schema. If the tables already exist in the user’s default schema, those tables continue to be used. Refer to DB2 documentation for a listing of Explain Plan tables that must be deleted in order to use the SYSTOOLS option. If set to FALSE, Explain Plan tables are created under the user’s default schema. |
Retain connection in pool after use |
This option determines what happens to a connection after it is unlocked by the ISQL window. If selected, the connection will be returned to the application connection pool. If unselected, the unlocked connection will be disconnected. |
Load Query Options |
If this option is not enabled, a set of default query options is loaded that customize your execution environment, and periodically sends those settings to the server. Enabling this option and specifying an XML file, forces load of a previously saved query options file each time an ISQL windows opens against this DBMS platform. This lets you override the default query options. You can also enable this option when saving a query options file. For information on other load and save options, specific query options offered, manually updating query options, and conditions for which query options are sent to the server, see Setting up the Execution Environment with Query options. |
ISQL Options - Sybase Tab
The Options Editor’s ISQL > Sybase tab controls the appearance and behavior of the SQL Editor when executing against a Sybase ASE environment.
- Note: For information on opening the Options Editor, see Specifying Application Preferences and Feature Options.
- Note: For information on using the SQL Editor, see Coding Environments/Editors.
Use the following table as a guide to modifying settings on this tab:
Option | Description |
---|---|
Auto-Commit changes |
Applies auto commit status changes to all open windows. |
Retain connection in pool after use |
This option determines what happens to a connection after it is unlocked by the ISQL window. If selected, the connection will be returned to the application connection pool. If unselected, the unlocked connection will be disconnected. |
Load Query Options |
If this option is not enabled, a set of default query options is loaded. That set of query options customize your execution environment, and periodically sends those settings to the server. Enabling this option and specifying an XML file, forces load of a previously saved query options file each time an ISQL windows opens against this DBMS platform. This lets you override the default query options. You can also enable this option when saving a query options file. For information on other load and save options, specific query options offered, manually updating query options, and conditions for which query options are sent to the server, see Setting up the Execution Environment with Query options. |
ISQL Options - Sybase IQ Tab
The Options Editor’s ISQL > Sybase IQ tab controls the appearance and behavior of the SQL Editor when executing against a Sybase IQ environment.
- Note: For information on opening the Options Editor, see Specifying Application Preferences and Feature Options.
- Note: For information on using the SQL Editor, see Coding Environments/Editors.
Use the following table as a guide to modifying settings on this tab:
Option | Description |
---|---|
Enable Set Query Options |
Sets the default value of the Send Set Options setting on the Query Options dialog. For details, see Setting up the Execution Environment with Query options. Changing this value does not affect ISQL sessions currently open. |
Auto-Commit changes |
Applies auto commit status changes to all open windows. |
Retain connection in pool after use |
This option determines what happens to a connection after it is unlocked by the ISQL window. If selected, the connection will be returned to the application connection pool. If unselected, the unlocked connection will be disconnected. |
Load Query Options |
If this option is not enabled, a set of default query options is loaded. That set of options customize your execution environment, and periodically sends those settings to the server. Enabling this option and specifying an XML file, forces load of a previously saved query options file each time an ISQL windows opens against this DBMS platform. This lets you override the default query options. You can also enable this option when saving a query options file. For information on other load and save options, specific query options offered, manually updating query options, and conditions for which query options are sent to the server, see Setting up the Execution Environment with Query options. |
ISQL Options - SQL Server Tab
The Options Editor’s ISQL > SQL Server tab controls the appearance and behavior of the SQL Editor when executing against a SQL Server environment.
- Note: For information on opening the Options Editor, see Specifying Application Preferences and Feature Options.
- Note: For information on using the SQL Editor, see Coding Environments/Editors.
Use the following table as a guide to modifying settings on this tab:
Option | Description |
---|---|
Enable Set Query Options |
Sets the default value of the Send Set Options setting on the Query Options dialog. For details, see Setting up the Execution Environment with Query options. Changing this value does not affect ISQL sessions currently open. |
Auto-Commit changes |
Applies auto commit status changes to all open windows. |
Retain connection in pool after use |
This option determines what happens to a connection after it is unlocked by the ISQL window. If selected, the connection will be returned to the application connection pool. If unselected, the unlocked connection will be disconnected. |
Load Query Options |
If this option is not enabled, a set of default query options is loaded. That set of options customize your execution environment, and periodically sends those settings to the server. Enabling this option and specifying an XML file, forces load of a previously saved query options file each time an ISQL windows opens against this DBMS platform. This lets you override the default query options. You can also enable this option when saving a query options file. For information on other load and save options, specific query options offered, manually updating query options, and conditions for which query options are sent to the server, see Setting up the Execution Environment with Query options. |
ISQL Options - MySQL Tab
The Options Editor’s ISQL > MySQL tab controls the appearance and behavior of the SQL Editor when executing against a MySQL environment.
- Note: For information on opening the Options Editor, see Specifying Application Preferences and Feature Options.
- Note: For information on using the SQL Editor, see Coding Environments/Editors.
Use the following table as a guide to modifying settings on this tab:
Option | Description |
---|---|
Retain connection in pool after use |
This option determines what happens to a connection after it is unlocked by the ISQL window. If selected, the connection will be returned to the application connection pool. If unselected, the unlocked connection will be disconnected. |
Load Query Options |
If this option is not enabled, a set of default query options is loaded. That set of options customizes your execution environment, and periodically sends those settings to the server. Enabling this option and specifying an XML file, forces load of a previously saved query options file each time an ISQL windows opens against this DBMS platform. This lets you override the default query options. You can also enable this option when saving a query options file. For information on other load and save options, specific query options offered, manually updating query options, and conditions for which query options are sent to the server, see Setting up the Execution Environment with Query options. |
ISQL Options - DB2 OS390 Tab
The Options Editor’s ISQL > DB2 OS390 tab controls the appearance and behavior of the SQL Editor when executing against a DB2 z/OS environment.
- Note: For information on opening the Options Editor, see Specifying Application Preferences and Feature Options.
- Note: For information on using the SQL Editor, see Coding Environments/Editors.
Use the following table as a guide to modifying settings on this tab:
Option | Description |
---|---|
Retain connection in pool after use |
This option determines what happens to a connection after it is unlocked by the ISQL window. If selected, the connection will be returned to the application connection pool. If unselected, the unlocked connection will be disconnected. |
Load Query Options |
If this option is not enabled, a set of default query options is loaded. That set of options customizes your execution environment, and periodically sends those settings to the server. Enabling this option and specifying an XML file, forces load of a previously saved query options file each time an ISQL windows opens against this DBMS platform. This lets you override the default query options. You can also enable this option when saving a query options file. For information on other load and save options, specific query options offered, manually updating query options, and conditions for which query options are sent to the server, see Setting up the Execution Environment with Query options. |
ISQL Options - Teradata Tab
The Options Editor’s ISQL > Teradata tab controls the appearance and behavior of the SQL Editor when executing against a Teradata environment.
- Note: Teradata datasources support is intended as a technical preview. Minimal functionality is provided. For information on technical previews, see the Read Me at http://docs.embarcadero.com.
- Note: For information on opening the Options Editor, see Specifying Application Preferences and Feature Options.
- Note: For information on using the SQL Editor, see Coding Environments/Editors.
Use the following table as a guide to modifying settings on this tab:
Option | Description |
---|---|
Retain connection in pool after use |
This option determines what happens to a connection after it is unlocked by the ISQL window. If selected, the connection will be returned to the application connection pool. If unselected, the unlocked connection will be disconnected. |
Load Query Options |
If this option is not enabled, a set of default query options is loaded. That set of options customizes your execution environment, and periodically sends those settings to the server. Enabling this option and specifying an XML file, forces load of a previously saved query options file each time an ISQL windows opens against this DBMS platform. This lets you override the default query options. You can also enable this option when saving a query options file. For information on other load and save options, specific query options offered, manually updating query options, and conditions for which query options are sent to the server, see Setting up the Execution Environment with Query options. |
ISQL Options - Editor Tab
The Options Editor’s ISQL > Editor tab controls the appearance and behavior of the SQL Editor window.
- Note: For information on opening the Options Editor, see Specifying Application Preferences and Feature Options.
- Note: For information on using the SQL Editor, see Coding Environments/Editors.
The table below describes the options and functionality on the Editor tab:
Group | Option | Description | Default |
---|---|---|---|
Window |
Show Toolbar and Show Status Bar |
Enables/disables these ISQL Window user interface elements. |
Selected |
Maximize on new or open |
Indicates that the ISQL Editor window should be maximized on opening. If you already have an active MDI Window that is maximized, the default behavior is to maximize a new child window. To deactivate this option, ensure you do not have any active MDI Windows. |
Selected | |
File Tracking |
Indicates that the ISQL Editor should use the File Tracking Facility to monitor the status of a file. If a file has been modified and saved outside the application, the application loads the most current version of the file into the IISQL Editor based on the options set for Auto-Reload File (see above.) |
Selected | |
Auto-Reload File |
If File Tracking is enabled, indicates that the application should automatically reload a file that has been externally modified without prompting you. If you turn this option off, you are prompted before reloading your file if external changes have been saved. |
Not selected | |
Auto-Save File |
Indicates that files in the ISQL Editor should automatically be saved at the indicated time interval. Backup files are saved to: In Rapid SQL, Backup files use a naming convention of the form ~ETxxxx.tmp.. For a listing of backup file names and the path of the file to which they correspond, see the registry key:
In Rapid SQL, |
Selected (5 minutes) | |
Command History |
Save File Before Overwriting |
Specifies the action you want the application to take when selecting a command from the Command History box. You have the option to be reminded to save a file before overwriting (Ask First), to automatically save a file before overwriting (Always), or to automatically overwrite the file with the command (Never). |
Ask First |
Save Most Recent |
Specifies the number of commands you want to save in the Command History list in the top of the ISQL Window toolbar. The maximum value is 99. |
15 | |
Printing |
Lets you select common printer options. | ||
Appearance |
Enable Syntax Highlighting |
Sets syntax highlighting on so that all keywords and comments are colored for easier reading and debugging. |
Selected |
Show Line Numbers |
Places line numbers in the left column of an ISQL Window. |
Selected | |
Enable Outlining |
Enables and disables outlining. |
Selected | |
Enable Text Wrapping |
Enables and disables a typical text wrap feature. |
Selected | |
Editor Font |
Sets the font face, style, and size displayed in the editor. |
Available | |
Syntax Colors |
Sets syntax coloring for keywords, comments, quotes, and default text for various file types and scripts from the Syntax Coloring dialog. |
Available | |
Formatting |
Auto Indent |
Sets automatic indentation for each carriage return, new line in your SQL script. |
Selected |
Expand Tabs and Tab Size |
Sets tabs as the specified number of spaces in result sets. |
Selected (4) | |
Clipboard Line Endings |
None |
When copying text from the editor, no substitution is made for end-of-line characters. This provides the fastest cut and paste operation. |
Selected |
Line Endings |
When copying text from the editor, end-of-line characters are replaced with platform-specific equivalents (Windows - CR LF, UNIX - LF, Macintosh - CR). This lets you copy text into environments such as Notepad, that require platform-specific end-of-line characters. This option avoids unnecessary characters and incorrect display, but cut-and-paste operations take more time to complete. |
ISQL Options - Auto format Tab
After opening the Options editor, you can make changes to the Auto Format tab. of the ISQL pane.
The Options Editor’s ISQL > Auto Format tab lets you specify the style and spacing of SQL statements in an ISQL window when you choose to auto format SQL in the ISQL editor.
- Note: For information on opening the Options Editor, see Specifying Application Preferences and Feature Options.
- Note: For information on using the SQL Editor, see Coding Environments/Editors.
On opening, the Preview area shows an SQL statement formatted according to the current Auto Format settings. Click Edit to open the Auto Format Options dialog. Use the following table as a guide to understanding and modifying the settings in this dialog:
Setting | Description |
---|---|
Keywords |
Lets you select a character case (UPPERCASE, LOWERCASE, INITIALCAPS, or NOCHANGE) formatting treatment for SQL keywords. |
Right Margin |
Specifies the maximum number of characters per line. |
New line before keyword |
If enabled, a new line is forced before every SQL keyword. If disabled, lines are only forced for statement type and clause type keywords. |
BEGIN..END block |
If enabled, empty BEGIN..END blocks occupy a single line. |
Stack lists |
If enabled, a new line and indenting is forced for each item in comma-separated list such as argument lists. |
List indent size |
If Stack lists is enabled, this control lets you specify the number of spaces each list item will be indented from the current offset. |
Parenthesis indent size |
Lets you specify the number of indenting spaces for forced lines following an open parenthesis. |
Conditions format style |
Specifies how conditions in clauses are formatted: CONDITIONS_WRAPPED - lines are not forced before conditions. CONDITIONS_STACKED_WITH_LEADING_OPERATORS - a new line is forced for each condition in a clause, with logical operators, if present for a line, displayed at the start of the line. CONDITIONS_STACKED_WITH_TRAILING_OPERATORS - a new line is forced for each condition in a clause, with logical operators, if present for a line, displayed at the end of the line. |
Conditions stack threshold |
For Conditions format style selections that specify stacking, this value specifies the minimum number of conditions that must appear in a clause before conditions are stacked. |
THEN statements |
If enabled, simple THEN clauses are kept to a single line. |
ISQL Options - Code Assist Tab
Code assist options are available on the following tabs:
ISQL Options - Code Assist - Main Tab
The Options Editor’s ISQL > Code Assist tab lets you activate and select options for coding assistance and error-detection features available from the ISQL editor:
- Code Complete : lets you insert or replace object names, selected from suggestion lists, as you edit a script. For more information, see Code Complete.
- Semantic validation: detects object name references to objects not present in the datasource index. For more information, see Semantic Validation.
- Real-time syntax checking: on-the-fly syntax checking is performed as you type. For more information, see Syntax Checking.
- Hyperlinks: lets you invoke object actions against objects referenced in a script. For more information, see Hyperlink Object Actions.
The ISQL - Code Assist tab has the following settings:
Group/Option | Description | |
---|---|---|
Code Complete |
Enable Code Complete |
Lets you enable or disable the Code Complete feature. When disabled, Code Complete cannot be invoked automatically or manually. Because of the overhead in maintaining internal resources used in implementing this feature, a slight performance increase can result from disabling the feature. |
Enable auto-activation and Auto-activation delay |
When auto-activation is disabled, the Code Complete feature must be invoked manually. When auto-activation is enabled, the Code Complete feature is invoked automatically each time the interval between keystrokes exceeds the specified Auto-activation delay. | |
Insert single proposals automatically |
Specifies that if a Code Complete suggestion list would contain only a single suggestion, that suggestion is inserted automatically. | |
Fully qualify completions automatically |
Specifies that Code Complete results are returned fully qualified, rather than the minimum required to identify the object. | |
Code Validation |
Enable Real-time syntax checking |
If enabled, syntax-checking is performed as you type. If disabled, syntax checks must be initiated manually. |
Severity levels for semantic validation problems |
Lets you select the severity level (ERROR, WARNING, or IGNORE) associated with detected semantic errors. The WARNING option provides a contrast to syntax errors, which are always flagged with a severity level of ERROR.The IGNORE setting disables the feature. For more information, see Semantic Validation. | |
Perform syntax and semantic validation on files smaller than |
Places an upper limit on the size of files for which automatic syntax checking and semantic validation are active. | |
DB Action Menu |
Enable DBAction menu in the editor |
Enables the Hyperlinks feature. |
Show DB Actions in submenu |
If unselected, Hyperlink menu actions are available as first level options in the context menu. If selected, Hyperlink menu actions are available as a DB Actions submenu. | |
Key used in conjunction with right-mouse |
Lets you select the key (CTRL, SHIFT, or CTRL+SHIFT) used in conjunction with right-clicking, that activates the object action menu against a supported object type reference in a script. The default keystroke combination is CTRL+right-click. | |
Performance |
Enables/disables the ISQL Performance feature. For more information see ISQL Performance. | |
Cache lifespan in minutes |
Allows you to select the update timing for the ISQL Performance feature. ISQL performance updates the cache information with the sample rate selected. For more information, see ISQL Performance. | |
Restore defaults |
Restores all settings on the tab to the original defaults. |
- Note: For information on opening the Options Editor, see Specifying Application Preferences and Feature Options.
- Note: For information on using the SQL Editor, see Coding Environments/Editors.
ISQL Options - Code Assist - Advanced Tab
Coding assistance and error detection features such as Hyperlink object actions, Code Complete, and Semantic Validation rely on:
- Parsing of SQL entered in the SQL Editor into keywords, object name references, data, and so on
- A database object index generated for a connected datasource. On the first connection to a datasource, an index of specified object types is generated, with an imposed, configurable, upper limit on the number of objects contained in the index. On each subsequent connection, the index is updated to reflect any additions or changes on the datasource.
- Note: The object index is stored in a persistent database with a database path of %TEMP%. With that in mind, the index may be deleted by the system administrator or automated administration-related processes.
- When coding assistance and error detection features are enabled, the index is queried for the names of objects referenced in your scripts queries. This information is then used for tasks such as recognizing object types, detecting misspelled object names, and populating suggestion lists.
The Options Editor’s ISQL > Code Assist > Advanced tab lets you force parsing, if required, and customize how the index is generated. Since there is performance overhead associated with generation and usage of the index, you can control the properties and usage of the index.
- Note: For information on opening the Options Editor, see Specifying Application Preferences and Feature Options.
The table below describes the options and functionality on the ISQL > Code Assist > Advanced Tab of the Options Editor:
Option | Description |
---|---|
Scan entire file for context |
This control is enabled only if the ISQL > Code Assist tab’s Enable Real-time syntax checking check box is deselected and the Severity levels for semantic validation problems is set to IGNORE. When this control is enabled, SQL Editor content continues to be parsed. That is, if you have disabled real-time syntax checking and effectively disabled semantic validation, you can still use the Hyperlinks feature. |
Limit scanning to files smaller than |
Lets you place an upper limit on the size of files parsed for Code Assist features. |
Object types to be indexed |
Lets you select specific object types (aliases, synonyms, functions, packages, procedures, tables, or views) that will be included in the object index. While this can be used to reduce the index size and therefore improve performance, Hyperlinks, Semantic Validation, and Code Complete functionality associated with object types not included in the index will not be available. |
Recycle cache space when index size exceeds |
This imposes a soft ceiling on the number of objects stored in the index. After updating the index on connection to a datasource, the total number of objects in the index is compared to this value. If the value is exceeded, the oldest definitions are deleted. |
The maximum number of results to return when querying the object index |
Specifies the number of results when querying against the cache databases, to improve performance when working with large databases. This limit is applied per object type. |
Refresh |
Each time you open an ISQL editor window, schema information for the object types supported is obtained for the Code Complete and Semantic Validation features. That information is updated with any modifications that you make and persists until the window is closed. The Refresh button ensures that the information is current in case other users or applications are modifying the schema while the current SQL editor session window is open. |