Assigns the specified value to a variable or output parameter.
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.
The value-expression must be assignment-compatible with the data type of the target-variable, see Assignments.
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, chapter 12, Declaring Variables.
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, chapter 12, The ROW Data Type and Mimer SQL Programmer's Manual, chapter 12, Row Value Expression, for more information.
ExampleSET firstName = 'Moira'; SET pos = position(' ' IN name); SET book.title = 'Grapes of Wrath'; SET bookTitle = ('0-201-43328-1','JDBC API Tutorial and Reference');
For more information, see the Mimer SQL Programmer's Manual, chapter 12, Assignment Using SET.
SQL/PSM YES Fully compliant.
Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40