ALLBASE/SQL Reference Manual (36216-90216)

230 Chapter8
Expressions
Expression
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
The first six of these have the same meaning that they have as fields in the
SQLCA in application programs. Note that in procedures, sqlerrd2 returns
the number of rows processed for all host languages. However, in
application programs, sqlerrd3 is used in COBOL, Fortran, and Pascal,
while sqlerr2 is used in C. ::activexact indicates whether a transaction is
in progress or not. For additional information, refer to the application
programming guides and to Chapter 4 , “Constraints, Procedures, and
Rules.”
AddMonthsFunction returns a value that represents a DATE or DATETIME value with a
certain number of months added to it.
AggregateFunction is a computed value; aggregate functions are defined in this
chapter.
Constant is a specific value; constants are defined in this chapter.
DateTimeFunction returns a value that is a conversion of a date/time data type into an
INTEGER or CHAR value, or from a CHAR value.
CurrentFunction returns a value that represents the current DATE, TIME, or
DATETIME.
LongColumnFunction returns information from a long column descriptor.
StringFunction returns a partial value or attribute of string data.
CASTFunction converts data from one data type to another.
(Expression) is one or more of the above primaries, enclosed in parentheses.
* multiplies two primaries.
/ divides two primaries.
+ adds two primaries.
− subtracts two primaries.
|| concatenates two string operands.
TIDFunction returns the database address of a row (or rows for a BULK SELECT) of a
table or an updatable view. You cannot use mathematical operators with
this function except to compare it (using = or <>) to a value, host variable,
or dynamic parameter.