Chat now with support
Chat with Support

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

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating