Declaring local variables of type row

Variables of type row can be declared once the row data type has been created.

Before you create a row data type:

Row data type variables can only be declared in SQL PL contexts including SQL procedures and functions where execution of the DECLARE statement is supported.

The following steps must be followed to declare a local row variable:
  1. Formulate a declare statement:
    1. Specify a name for the variable.
    2. Specify the row data type that will define the variable. The specified row data type must be already defined in the database.
    The following is an example of how to formulate a DECLARE statement that defines a row variable of type empRow:
    
DECLARE r1 empRow;
  2. Execute the DECLARE statement within a supported context.

If execution of the DECLARE statement is successful, the row variable is created.

Upon creation of a row variable each field in the row is initialized to a NULL value.

The row variable can be assigned values, be referenced, or passed as a parameter.