ALLBASE/SQL Reference Manual (36216-90216)

228 Chapter8
Expressions
Expression
Expression
An expression can consist of a primary or several primaries connected by arithmetic
operators. A primary is a signed or unsigned value derived from one of the items listed in
the SQL syntax below.
Scope
SQL Data Manipulation Statements
SQL Syntax
[+
-] { ColumnName
USER
:HostVariable [[INDICATOR] :IndicatorVariable ]
?
:LocalVariable
:ProcedureParameter
::Built-inVariable
AddMonthsFunction
AggregateFunction
Constant
DateTimeFunction
CurrentFunction
LongColumnFunction
StringFunction
CASTFunction
(Expression)
TIDFunction }
[ { *
/
+
-
||} [+
- ] { ColumnName
: HostVariable [[INDICATOR]: IndicatorVariable ]
?
: LocalVariable
: ProcedureParameter
:: Built-inVariable
AddMonthsFunction
AggregateFunction
Constant
DateTimeFunction
CurrentFunction
LongColumnFunction
StringFunction
CASTFunction
Expression) }] [ ...]