DB2 10.5 for Linux, UNIX, and Windows

Row types

A row data type is a user-defined type containing an ordered sequence of named fields each with an associated data type.

A row type can be used as the type for global variables, SQL variables, and SQL parameters in SQL PL to provide flexible manipulation of the columns in a row of data, typically retrieved using a query.

Features of the row data type
The features of the row data type make it useful for simplifying SQL PL code.
Restrictions on the row data type
It is important to note the restrictions on the use of the row data type before using it or when troubleshooting an error that might be related to its use.
Row variables
Row variables are variables based on user-defined row data types. Row variables can be declared, assigned a value, set to another value, or passed as a parameter to and from SQL procedures. Row variables inherit the properties of the row data types upon which they are based. Row variables are used to hold a row of data from within a result set or can be assigned other tuple-format data.
Creating row variables
To create row variables you must first create the row type and then declare the row variable.
Assigning values to row variables
Values can be assigned to variables of type row in multiple ways. A row variable value can be assigned to another row variable. Variable field values can be assigned and referenced. Field values of a row are referenced by using a single-dot "." notation.
Comparing row variables and row field values
Row variables cannot be directly compared even if they are the same row data type, however individual row fields can be compared.
Referencing row values
Row values and row field values can be referenced within SQL and SQL statements.
Passing rows as routine parameters
Row type values and arrays of row type variables can be passed as parameters to procedures and functions. Procedures support these data types as IN, OUT, and INOUT parameters.
Dropping a row data type
Dropping a row data type is done when the row data type is no longer required or when you want to reuse the name of an existing row data type.
Examples: Row data type use
Examples of row data type use provide a useful reference for understanding how and when to use the row data type.

Related concepts:

Assigning values to a row variable using the SET statement

Creating row variables

Examples: Row data type use

Features of the row data type

Passing rows as routine parameters

Referencing row values

Restrictions on the row data type