SQL Optimizer for DB2 LUW 4.4.1 - User Guide

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.

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 .

2. Select the Editor tab.

3. Under the Editing section, click 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:

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 .

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 .

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 .

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