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.
OR - AND
Set the placement of the AND an OR operators according to the operands followed by them. See the example below.
Left
WHERE
AND ...
AND ...
AND ...
Separate
WHERE
...
AND
...
AND
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".
Space before bracket
Adds a "space" character before the opening bracket and after the closing one.
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.
