ALLBASE/SQL Reference Manual (36216-90216)

Chapter 9 269
Search Conditions
IN Predicate
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, the string is
truncated.
HostVariable contains a value in an application program being input to
the expression.
IndicatorVariable names an indicator variable, whose value determines
whether the associated host variable contains a NULL
value:
> = 0 the value is not NULL
< 0 the value is NULL (The value in the host variable will be
ignored.)
? is a place holder for a dynamic parameter in a prepared
SQL statement in an application program. The value of
the dynamic parameter is supplied at run time.
LocalVariable contains a value in a procedure.
ProcedureParameter contains a value that is passed into or out of a procedure.
Built-inVariable is one of the following built-in variables used for error
handling:
• ::sqlcode
• ::sqlerrd2
• ::sqlwarn0
• ::sqlwarn1
• ::sqlwarn2
• ::sqlwarn6
• ::activexact