Chat now with support
Chat mit Support

SQL Optimizer for DB2 LUW 5.0 - 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

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.

 

Editor Panes Shortcuts

The following list is the common shortcut keys provided for users to quickly accomplish tasks that is performed frequently within the Editor panes for SQL Editor and SQL Formatter window.

Action

Shortcut Keys

Delete next word

Ctrl+Delete

Delete previous word

Ctrl+Backspace

Delete next character

Delete

Delete previous character

Backspace

Delete current line

Ctrl+Y

Highlight a word 

Shift+Ctrl+Left or Right Arrow

Highlight a character

Shift+Left or Right Arrow

Cursor forward a word

Ctrl+Right Arrow

Cursor backward a word

Ctrl+Left Arrow

Insert mode

Insert

Insert a new line character

Shift+Ctrl+M

Bring up Member Lookup

Ctrl+Spacebar

Bring up Argument Lookup

Shift+Ctrl+Spacebar

Comment

Shift+Ctrl+C

Uncomment

Shift+Ctrl+N

Indent

Shift+Ctrl+I

Outdent

Shift+Ctrl+O

Uppercase

Shift+Ctrl+U

Lowercase

Shift+Ctrl+L

Quick Find

Ctrl+Alt+F

Find

Ctrl+F

Find Next

F3

Replace

Ctrl+Alt+R

Go to Line

Ctrl+Alt+G

Select All

Ctrl A

Cut

Ctrl X

Copy

Ctrl C

Paste

Ctrl V

Undo

Ctrl Z

Save

Ctrl S

 

Verwandte Dokumente

The document was helpful.

Bewertung auswählen

I easily found the information I needed.

Bewertung auswählen