Sybase Adaptive Server Anywhere - Expressions

Expressions
230
Expressions
expression:
case-expression
| constant
| [ correlation-name .] column-name [ java-ref ]
| -
expression
| expression operator expression
| ( expression )
|
function-name ( expression , ... )
|
if-expression
| [ java-package-name. ] java-class-name java-ref
| special value
| ( subquery )
|
variable-name [ java-ref ]
case-expression:
{ CASE search-condition
... WHEN expression
... THEN,...
... [ ELSE
expression ]
END
| 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
java-ref:
. field-name [ java-ref ]
| >> field-name [ java-ref ]
| .
method-name ( [ expression ,...] ) [ java-ref ]
| >> method-name ( [ expression ,...] ) [ java-ref ]
Syntax
Parameters