Chat now with support
Chat mit Support

SQL Optimizer for DB2 LUW 4.3.1 - User Guide

SQL Optimizer for IBM® DB2® LUW
About SQL Optimizer for IBM DB2 LUW Getting Started Options SQL Scanner SQL Optimizer SQL Formatter SQL Inspector Database Explorer SQL Repository Index Impact Analyzer Index Usage Analyzer User-Defined Temp Table Editor Functions SQL Functions SQL Information and Functions Activity Log
Tutorials About us Copyright

Auto Correction

Auto correction automatically corrects any typo and spelling errors, if the auto correction option is turned on. For example, if " teh " is typed followed by a space, it will automatically be corrected to "the". Auto correction entries are user-defined and can be modified in the Options window.

To setup auto correction

  1. Click image\B_Options.gif.

  2. Select the Editor tab.

  3. Under the Editing section, click image\B_Ellipse.gif next to the Auto Correction checkbox to open the Auto Correction Settings window.

  4. Modify the auto correction entries

  5. Click Apply.

  6. Click OK.

  7. Check the Auto Correct checkbox in order for auto correction function to be enabled.

The available auto correction entries are listed on the list box. Each entry has a Replace text (the original text typed) and With text (the replacement text).

Action keys are the keys that will activate the auto correction. When you type the Replace text and follow it by any action key, the replacement takes place. No whitespaces are needed to separate each key. By default, the action keys are ";,:=[]\ n\t\s" representing the following:

Action Key

Description

;

semi-colon

,

comma

:

colon

=

equal sign

[

left bracket

]

right bracket

\n

new line

\t

tab

\s

space

To add an correction entry

  1. Click Add.

  2. Enter the original text [Replace] and replacement text [With].

  3. Click Apply.

  4. Click OK.

  5. Click Apply.

  6. Click Close.

To modify an auto correction entry

  1. Select the entry to be modified from the Auto Corrections box.

  2. Click Edit.

  3. Modify the text.

  4. Click OK.

  5. Click Apply.

  6. Click Close.

To delete an auto correction entry

  1. Select the entry to be modified from the Auto Corrections box.

  2. Click Delete.

  3. Click Apply.

  4. Click Close.

 

Brackets Pairing

Simple mistakes are often made during SQL construction because of uneven left and right brackets. An easy way to identify the corresponding open and closed brackets for round brackets, curly brackets, or square brackets is to turn on the Bracket Pairing parameter in the Options window.

To enable or disable Bracket Pairing

  1. Click image\B_Options.gif.

  2. Select the Editor tab.

  3. Under the General section, select Bracket Pairing.

 

Comment and Uncomment Text

It is possible to comment or uncomment a line of text by selecting the line or highlighting the text and use the Comment and Uncomment functions. These two functions use the single line comment delimiter "- -". Commenting out a line means that the line will be ignored during execution.

To comment a line of text

  1. Select the text or place the cursor at the line to be commented.

  2. Click image\B_Comment.gif.

  3. Notice that the beginning of a text or line prefix is marked with the " - - " delimiter.

To uncomment a line of text

  1. Select the text or place the cursor at the line to be uncommented.

  2. Click image\B_Uncomment.gif.

  3. Notice the first occurrence of the " - - " comment delimiter will be removed.

 

Customize Editable Panes

There are many ways to customize the behavior of editable panes; the editor options can be set in the Options window under the Editor tab. These options include:

Editor Option

Description

Use tab characters

Specify whether to use the tab character (ASCII 9) instead of spaces.

Smart tab

Specify whether to tab to align the next non-whitespace character of the preceding line.

Use lowercase for object name

Specify whether to use lowercase for object names.

Block cursor for overwrite

Specify whether to change to a block cursor for overwrite mode. Overwrite mode will overwrite existing text when is text entered at the cursor. You can toggle between Insert and Overwrite mode using the Insert key.

Show all characters

Specify whether to show all characters including spaces, new lines and tabs.

Right margin

Specify whether to show the right margin and define the width.

Gutter

Specify whether to show the gutter and line number, and define the gutter width.

Block indent step size

Specify the block indent character size.

Tab size

Specify the tab character length.

 

Verwandte Dokumente

The document was helpful.

Bewertung auswählen

I easily found the information I needed.

Bewertung auswählen