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

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 DBArtisan, %APPDATA%\DBArtisan\Backup\. 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 DBArtisan, HKEY_CURRENT_USER\Software\IDERA\DBArtisan\version\Backup	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
• ISQL Options - Code Assist - Advanced Tab

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.