Chat now with support
Chat with Support

SQL Optimizer for DB2 LUW 4.4.1 - User Guide

SQL Optimizer for IBM® DB2® LUW
UsageStatistics 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

About Editor Functions

Editor functions are available on all editable windows to help format and construct SQL statements. The layout of the SQL statement is important to make it easier to read and maintain particularly when dealing with large and complicated SQL statements.

Editor functions settings can be changed within the Options window under the Editor tab.

Button or Menu

Function

 

Syntax Highlight

 

Auto Correction

 

Pairing Brackets

 

Argument Lookup

 

Member Lookup

Edit Menu

image\B_Indent.gif

 

Indent

Edit Menu

image\B_Outdent.gif

Outdent

Edit Menu

image\B_Comment.gif

Comment

Edit Menu

image\B_Uncomment.gif

Uncomment

Edit Menu

image\B_Uppercase.gif

Uppercase

Edit Menu

image\B_Lowercase.gif

Lowercase

 

 

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.

 

Related Documents