iAnywhere.com - Expressions in UltraLite

Expressions are formed by combining data, often in the form of column references, with operators or functions.

case-expression:
CASE expression
WHEN expression
THEN expression,...
[ ELSE expression ]
END

alternative form of case-expression:
CASE
WHEN search-condition
THEN expression,...
[ ELSE expression ]
END

constant:
integer | number | string | host-variable

special-value:
CURRENT { DATE | TIME | TIMESTAMP }
| NULL
| SQLCODE
| SQLSTATE

if-expression:
IF condition
THEN expression
[ ELSE expression ]
ENDIF

input-parameter:
{ ? | :name [ : indicator-name ] }

operator:
{ + | - | * | / | || | % }