Assigning values to row variables - IBM DB2 9.7 for Linux, UNIX, and Windows

Supported assignments to row data types
A variety of values are supported for assignment to rows and row fields.

Assigning values to a row variable using the SET statement
Assigning values to a row variable can be done using the SET statement. A row value can be assigned to a row variable. A row field value or expression can be assigned to a row field.

Assigning row values to row variables using SELECT, VALUES, or FETCH statements
A row value can be assigned to a variable of type row by using a SELECT INTO statement, a VALUES INTO statement, or a FETCH INTO statement. The field values of the source row value must be assignable to the field values of the target row variable.