|
|
The assignment statement is used in a procedure to assign
a value to a local variable or procedure parameter.
Procedures only
{:LocalVariable
:ProcedureParameter} = Expression;
- LocalVariable
identifies the local variable to which a value is being assigned. The
variable name has a : prefix. Local variables are declared in the
procedure definition using the DECLARE statement.
- ProcedureParameter
identifies the procedure parameter to which a value is being assigned.
The procedure parameter has a : prefix. Parameters are declared in
parentheses following the procedure name in the procedure
definition.
- Expression
identifies an expression whose value is assigned to the local
variable. The Expression may include anything that is
allowed in an SQL expression except host variables, subqueries, column
references, dynamic parameters, aggregate functions, date/time functions
involving column references, string functions, TID functions, and long
column functions. Local variables, built-in variables, and procedure
parameters may be included. See Chapter 8
"Expressions" for more information.
Host variables are not allowed anywhere in procedures, including
Expressions assigned to local variables or
parameters. However, local variables, built-in variables, and
parameters may be used in an Expression anywhere a
host variable would be allowed in an application program.
The data type of the expression result must be compatible with
that of the parameter or variable to which it is being
assigned.
Anyone can use the assignment statement in a procedure definition.
:msg = 'Vendor number found in "Orders" table.';
:SalesPrice = :OldPrice;
:NewPrice = :SalesPrice*.80;
:nrows = ::sqlerrd2;
|