Toad for DB2 7.4.1 - Installation Guide

General Editor Options

Use this page of the Options dialog to specify some general display and behavior options to use in the SQL Editor.

To set general editor options

1. Select Tools | Options |Editor | General.

2. Review the following for additional information:

   Background	Select a background color to use in the Editor. To create a custom color, select the Custom tab in the color palette. Then right-click in one of the empty squares (bottom rows) to open the custom Color dialog.
   Apply connection color	Select this checkbox to use the connection category color as the background color in the Editor. Default: Cleared
   Enable bracket highlighting	Select this checkbox to highlight the matching bracket if a bracket is selected with the cursor. Default: Cleared
   Show indicator margin	Select this checkbox to create a margin on the left side of the Editor. Default: Selected
   Show line numbers	Select this checkbox to display a line number in the left margin. Default: Cleared
   Show whitespace glyphs	Select this checkbox to display the glyphs. Default: Cleared
   Show end-of-line glyphs	Select this checkbox to display glyphs in the end of each line. Default: Cleared
   Show line modification markings	Select this checkbox to add a bar in the left margin that indicates that a line has been modified. Default: Selected
   Show indention guides	Select this checkbox to use vertical lines to indicate the amount of indention for text. Default: Selected
   Show delimiter strip after	Select this checkbox to use vertical line to indicate the preferable length for the row (in characters).
   Default language	Select the default language to use for syntax highlighting if the file does not have a connection or a known extension. Note: This option applies only when opening a file in a new Editor window. If a file with an unknown extension is already open in an Editor and you select a default language, the language is not applied to the open file.    Default: SQL
   File encoding type	Select the default type of encoding to use when saving files. Note: You can manually change the encoding type for an individual file by right-clicking the Editor window and selecting Character Encoding Default: Windows system settings
   Use individual connection for each open editor	Select this checkbox to create a separate database connection for each Editor (the first time you execute a statement) and a separate database connection for each Data tab in the Database Explorer (the first time you select the tab and data is queried). The database connection for each Editor and Data tab remain open until you close the associated window; however, the connections remain in an inactive state if a statement is not currently executing.   If cleared, all open Editors and Data tabs share the same database connection when the connection is inactive. See Understand Toad Connections for more information. Note: Although you can share a database connection, any commits apply to the selected window only. Default: Selected
   Use Large Script Mode for files larger than (KB)	Select this checkbox to disable the following features when loading files that are larger than 2 MB: Outlining/code folding Word-wrap Content dividers (VB type feature) Lexical parsing (syntax highlighting) Semantic parsing (open/close brace matching, code folding features) Indention guides Line modification markings Code Navigator Default: Selected
   Refresh Object Explorer after executing Create/Drop DDL	Select this checkbox to enable auto refresh of the Object Explorer after a Create or Drop DDL statement is executed. Clear this checkbox to disable auto refresh after Create/Drop DDL statement execution. Default: Selected

Tips:

• To navigate to the directory where option settings are stored, click the Application Data Directory link in the About dialog (Help | About).

• To search for a partial or complete option name or value, use the Search field at the bottom of each Options page. See About Options for more information.

Related Topics

About Editing SQL