ALLBASE/SQL Reference Manual (36216-90216)

Chapter 11 447
SQL Statements E - R
INSERT
ignored.)
NOTE To be consistent with the standard SQL and to support portability of code, it
is strongly recommended that you use a −1 to indicate a null value. However,
ALLBASE/SQL interprets all negative indicator variable values to mean a
null value.
? 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
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.”
ConversionFunction 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 indicates the value of the current DATE, TIME, or DATETIME
function.
Integer specifies a value of type INTEGER or SMALLINT.
Float specifies a value of type FLOAT or REAL.
Decimal specifies a value of type DECIMAL.
CharacterString specifies a CHAR, VARCHAR, DATE, TIME, DATETIME, or
INTERVAL value.
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.