Online Documentation for SQL Manager for DB2

SQL Words


The SQL words page of the SQL Formatter section allows you to select the key words for each action of SQL formatter and to set formatting parameters.

 

Wrap first element

Wraps the selected text at a specific column. Select the SQL key words after which formatting should be applied.

 

Params in line/list

Allows you to display the parameters followed by the defined key words in list or in line.

 

Editor Options - SQL Formatter - SQL Words

 

 

OR - AND

Set the placement of the AND an OR operators according to the operands followed by them. See the example below.

 

RadioButton Left

 

WHERE

 AND ...

 AND ...

 AND ...

 

RadioButton Separate

 

WHERE

 ...

  AND

 ...

  AND

 

RadioButton Right

 

WHERE

 ... AND

 ... AND

 ... AND

 

 

The Keywords case / Identifiers case options allow you to define the case of the corresponding items.

You can choose UPPER, lower, Capitalize.

Default case means that the name of the identifier/keyword remains "AS IS".

 

 

CheckBox Space before bracket

Adds a "space" character before the opening bracket and after the closing one.

 

CheckBox Space into brackets

Adds a "space" character after the opening bracket and before the closing one.

 

Indent in list

Sets the size of indent relatively to the previous string.