ALLBASE/SQL Reference Manual (36216-90216)

Chapter 9 279
Search Conditions
Quantified Predicate
SubQuery A subquery is a nested query. Subqueries are presented fully in the
description of the SELECT statement.
ValueList defines a list of values to be compared against the expression's value. The
syntax for
ValueList is:
{ USER
CurrentFunction
[ +
- ] { Integer
Float
Decimal }
‘CharacterString’
OxHexadecimalString
: HostVariable [[INDICATOR]: IndicatorVariable ]
?
: Local Variable
: ProcedureParameter
:: Built-inVariable
LongColumnFunction
StringFunction } [, ...]
USER USER evaluates to login name. In ISQL, it evaluates to
the login name of the ISQL user. From an application
program, it evaluates to the login name of the individual
running the program. USER behaves like a CHAR(20)
constant, with trailing blanks if the login name has fewer
than 20 characters.
CurrentFunction indicates the value of the current DATE, TIME, or
DATETIME.
Integer indicates a value of type INTEGER or SMALLINT.
Float indicates a value of type FLOAT.
Decimal indicates a value of type DECIMAL.
CharacterString specifies a CHAR, VARCHAR, DATE, TIME,
DATETIME, or INTERVAL value. Whichever is shorter --
the string or the expression value -- is padded with blanks
before the comparison is made.
HexadecimalString specifies a BINARY or VARBINARY value. If the
string is shorter than the target column, it is padded with
binary zeroes; if it is longer than the target column, it is
truncated.
HostVariable identifies the host variable containing the column value.