Declare row variables

To declare a row host variable, use the following syntax. 

1 (1)  row?  ’ named row
type ’?  ( + , field name field type ) + , variable name  ;
Notes:
  • 1 HCL OneDB™ extension
Element Purpose Restrictions SQL syntax
field name Name of a field in the row variable Must match the corresponding field name in any associated row-type column. Identifier segment in the HCL OneDB Guide to SQL: Syntax
field type Data type of the field name field in the row variable Can be any data type except SERIAL, SERIAL8, BIGSERIAL, TEXT, or BYTE. Data Type segment in the HCL OneDB Guide to SQL: Syntax
named row type Name of the named row type to assign to the row variable Named row type must be defined in the database. Identifier segment in the HCL OneDB Guide to SQL: Syntax
variable name Name of the ESQL/C variable to declare as a row variable Name must conform to language-specific rules for variable names.