ASA SQL Reference
SQL Language Elements
expression:
case-expression
| constant
| [correlation-name.]column-name
| - expression
| expression operator expression
| ( expression )
| function-name ( expression, ... )
| if-expression
| special value
| ( subquery )
| variable-name
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
| USER
if-expression:
IF condition
THEN expression
[ ELSE expression ]
ENDIF
operator:
{ + | - | * | / | || | % }
Anywhere.
Must be connected to the database.
None.
Expressions are formed from several different kinds of elements. These are discussed in the following sections.
For information on functions, see SQL Functions. For information on variables, see Variables.
The IF condition is not supported in Adaptive Server Enterprise.
For other differences, see the separate descriptions of each class of expression, in the following sections.
Constants in expressions
Column names in expressions
Subqueries in expressions
IF expressions
CASE expressions
Compatibility of expressions