A row expression specifies a row of data that could have
a specific user-defined row type or the built-in data type ROW.
Authorization
The use of some of the row
expressions may require having the appropriate authorization. For
these row expressions, the privileges held by the authorization ID
of the statement must include the following authorization:
- row-variable. For information about
authorization considerations when row-variable is
a global variable, see "Global variables".
- row-function-invocation. The
authorization to execute the function. For information about authorization
considerations, see "Function invocation" in the "Functions" topic
- expression. Authorizations might be
required for the use of certain expressions referenced in a row-expression.
For information about authorization considerations, see "Expressions".
Syntax
row-expression
|--+-row-variable--------------------+--------------------------|
+-row-case-expression-------------+
+-row-cast-specification----------+
+-row-array-element-specification-+
+-row-field-reference-------------+
'-row-function-invocation---------'
Description
- row-variable
- A variable that is defined with row type.
- row-case-expression
- A case-expression that returns a row type.
- row-cast-specification
- A CAST that returns a row type.
- row-array-element-specification
- An array-element-specification of an array with row type elements.
- row-field-reference
- A field-reference of a row where the field is also a row type
- row-function-invocation
- A function-invocation of a user-defined
function that has a return type that is a row type. The function could
return a user-defined row type or the data type ROW with defined field
names and field types.
Notes
- Row expressions can be used to generate a row within SQL PL contexts.
DB2 10.5 for Linux, UNIX, and Windows