A value can be specified in the following ways:
as a literal
with a user variable when the statement is not part of a routine (see section "Host variables")
with a parameter (see "CREATE PROCEDURE - Create procedure") or a local variable (see "COMPOUND - Execute SQL statements in a common context") when the statement is part of a routine
with a placeholder "?" for values which are not yet known
(in a dynamic statement or cursor description, see section "Dynamic SQL")
value ::=
{
literal |
: host_variable [[INDICATOR] : indicator_variable ] |
routine_parameter |
local_variable |
?
}
literal
Alphanumeric literal, national literal, special literal, numeric literal or time literal.
host_variable
Name of the host variable that contains the value.
If you have specified an indicator variable and the value of the indicator variable is negative, the NULL value is used instead of the value of the host variable.
indicator_variable
Name of an indicator variable for the preceding host variable. The data type of indicator_variable is SMALLINT.
routine_parameter
Name of a routine's parameter which contains the value.
local_variable
Name of a routine's local variable which contains the value.
? Placeholder in a dynamic SQL statement.