Row-Type Text Representation

The DataBlade API supports a text representation for row types as a quoted string with the formats that the following table shows.

Row Type

Text Representation

Unnamed

"ROW(fld_value1, fld_value2, ...)"

Named

"row_type(fld_value1, fld_value2, ...)"

The text representations in the preceding table use the following abbreviations:

fld_value1, fld_value2

are the text representations of the field values.

row_type

is the name of the named row type.

A row type in its text representation is often called a row-type string. For example, suppose you have the following unnamed row type defined:

ROW(fld1 INTEGER, fld2 CHAR(20))

The following row-type string provides the text representation for this unnamed row type:

"ROW(7, 'Dexter')"

For a detailed description of the text representation of a row type, see the description of the Literal Row segment in the IBM Informix: Guide to SQL Syntax.