Data Statement Rules
Introduction
Section titled “Introduction”Data statement layout rules control a set of options that can modify the way data statements are written.
Data Statement
Section titled “Data Statement”
Join condition placement
Specifies if the join condition is to be placed on a separate line than the join.
| Setting | Description |
|---|---|
| Place on newline | Join condition is placed on a newline. |
| Place on same line | Join condition is placed on the same line as the join. |
Join condition indention
| Setting | Description |
|---|---|
| Indent with | Defines the number of spaces to indent the join condition towards the join keyword when the join condition is placed at a newline. This rule depends on the Place join condition on a newlinerule. |
Join clause alignment
Specifies the join clause alignment.
| Setting | Description |
|---|---|
| Place aligned with statement | Specifies the join clause to be aligned with the statement. |
| Place aligned with table sources | Specifies the join clause to be aligned with the table sources in the join list. |
Nested join expression indention
Specifies if to indent joins that are between a join and the join condition.
| Setting | Description |
|---|---|
| Indent nested joins | If checked joins will be indented otherwise nested joins won’t be indented. |
The first column in a data statement placement
| Setting | Description |
|---|---|
| Place on a newline | Placement of the first column in a comma list in data statement (SELECT, INSERT, DELETE, UPDATE). |
Column padding in a select list
| Setting | Description |
|---|---|
| Padding width | Set the padding width of columns in the select list and change the placement of the column alias. The rule is ignored if the column length is greater than the selected length or the comma list breaks rule is disabled. |
R the variable declaration
| Setting | Description |
|---|---|
| Padding width | Set the padding width of the variable in its declaration statement. The rule is ignored if the variable length is greater than the selected length or the comma list breaks rule is disabled. |
Left operand padding in an assignment expression
| Setting | Description |
|---|---|
| Padding width | Set the padding width of the first operand in an assignment expression in the select list. The rule is ignored if the first operand length is greater than the selected length or the comma list breaks rule is disabled. |