Mimer SQL Reference Manual TOC PREV NEXT INDEX

Mimer Developer Site

www.mimer.com/developer


SET


Assigns the specified value to a variable or output parameter.

Usage

Procedural/Interactive.

Description

The SET statement directly assigns the specified value-expression to a target-variable, see Target Variables. Where the target of the assignment is a routine parameter, it must have mode OUT or INOUT.

Restrictions

The value-expression must be assignment-compatible with the data type of the target-variable, see Assignments.

Notes

Where the target of the assignment is a declared variable, its name may be qualified with a scope label, see the Mimer SQL Programmer's Manual.

If the target of the assignment is a variable declared with the ROW data type, a row value expression may be specified for expression.

If is possible to assign a value to a field of a variable declared with the ROW data type by using the following syntax to refer to the field:
routine-variable.field-name.

See the Mimer SQL Programmer's Manual for details of the ROW data type and row value expressions respectively.

Standard Compliance

Standard
Compliance
Comments
SQL/PSM
YES
Fully compliant.



Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
dbtechnology@upright.se
Mimer SQL Reference Manual TOC PREV NEXT INDEX