Values can be specified in SQL in the formats shown below.
value-expression::={[+|-]primary|value-expression {+|-|*|/}
[{+|-}] primary|value-expression * primary
|value-expression / primary|value-expression |
| primary}
primary::={(value-expression)|item-specification
|unsigned-value-specification
|set-function|window-function|scalar-function
|CASE-clause|CAST-specification|labeled-interval
|function-call|scalar-subquery|NEXT VALUE-expression}
value-expression::={literal|? parameter |:embedded-variable
[:indicator-variable]
|USER|CURRENT DATE|CURRENT_DATE
|CURRENT_TIME|CURRENT_TIMESTAMP[(p)]
|CURRENT DATE|CURRENT DATE
|CURRENT TIME|CURRENT TIMESTAMP[(p)]
|[statement-label.]SQL-variable-name
|[[authorization-identifier.] routine-identifier.]
SQL-parameter-name
|SQLCODE|SQLCOUNT
|SQLCODE_OF_LAST_CONDITION
|SQLERRM_OF_LAST_CONDITION}
unsigned-value-specification::={unsigned-numeric-literal|general-literal
|? parameter|:embedded-variable
[:indicator-variable]
|USER|CURRENT DATE|CURRENT_DATE
|CURRENT_TIME
|CURRENT_TIMESTAMP[(p)]
|CURRENT DATE|CURRENT DATE
|CURRENT TIME
|CURRENT TIMESTAMP[(p)]
|[statement-label.]SQL-variable-name
|[[authorization-identifier.]
routine-identifier.]
SQL-parameter-name
|SQLCODE|SQLCOUNT
|SQLCODE_OF_LAST_CONDITION
|SQLERRM_OF_LAST_CONDITION}
literal::={numeric-literal|general-literal}
general-literal::={character-string-literal|hexadecimal-character-string-literal
|national-character-string-literal
|mixed-character-string-literal}
item-specification::={column-specification
|[statement-label.]SQL-variable-name
|[[authorization-identifier.] routine-identifier.]
SQL-parameter-name
|component-specification}