ALLBASE/SQL Reference Manual (36216-90216)

446 Chapter11
SQL Statements E - R
INSERT
CREATE VIEW commands, if no column name list exists. Character and
date/time literals must be in single quotes.
SingleRowValues defines column values when you insert a single row. The syntax for
SingleRowValues is presented separately below and includes single row
syntax for statements that do not use dynamic parameter substitution.
BulkValues defines values when you use the BULK option. The syntax for
BulkValues is presented separately below and includes bulk value syntax
for statements that do not use dynamic parameter substitution.
? is a dynamic parameter value that defines column values within a
prepared insert statement that uses dynamic parameter substitution. The
syntax for
DynamicParameterValues is presented separately below and
includes both single row and bulk processing for such statements.
SQL Syntax — SingleRowValues
The following syntax applies to single row inserts that do not use dynamic parameter
substitution.
{NULL
USER
: HostVariable [[INDICATOR]: IndicatorVariable ]
?
: LocalVariable
:ProcedureParameter
:: Built-inVariable
ConversionFunction
CurrentFunction
[+
-]{ Integer
Float
Decimal }
‘ CharacterString ’
OxHexadeciamalString
‘ LongColumnIOString ’ }[,...]
Parameters — SingleRowValues
NULL indicates a null value.
USER evaluates to the current DBEUserID. 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.
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