SYSCAT.ROWFIELDS catalog view
Each row represents a field that is defined for a user-defined row data type.
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| TYPESCHEMA | VARCHAR (128) | Schema name of the row data type that includes the field. | |
| TYPEMODULENAME | VARCHAR (128) | Y | Unqualified name of the module to which the row data type belongs. The null value if not a module row data type. |
| TYPENAME | VARCHAR (128) | Unqualified name of the row data type that includes the field. | |
| FIELDNAME | VARCHAR (128) | Field name. | |
| FIELDTYPESCHEMA | VARCHAR (128) | Schema name of the data type of the field. | |
| FIELDTYPEMODULENAME | VARCHAR (128) | Y | Unqualified name of the module to which the data type of the field belongs. The null value if the field data type is not a module user-defined data type. |
| FIELDTYPENAME | VARCHAR (128) | Unqualified name of the data type of the field. | |
| ORDINAL | SMALLINT | Position of the field in the definition of the row data type, starting with 0. | |
| LENGTH | INTEGER | Length of the field data type. For decimal types, contains the precision. | |
| SCALE | SMALLINT | For decimal types, contains the scale of the field data type; for timestamp types, contains the timestamp precision of the field data type; 0 otherwise. | |
| TYPESTRINGUNITS | VARCHAR (11) | Y | In a Unicode database, the string units that apply to a character string or graphic string data type. Otherwise, the null value. |
| STRINGUNITSLENGTH | INTEGER | Y | In a Unicode database, the declared number of string units for a character string or graphic string data type. Otherwise, the null value. |
| CODEPAGE | SMALLINT | For string types, denotes the code page; 0 indicates FOR BIT DATA; 0 for non-string types. | |
| COLLATIONSCHEMA | VARCHAR (128) | Y | For string types, the schema name of the collation for the field; the null value otherwise. |
| COLLATIONNAME | VARCHAR (128) | Y | For string types, the unqualified name of the collation for the field; the null value otherwise. |
| NULLS | CHAR (1) | Reserved for future use. | |
| QUALIFIER | VARCHAR (128) | Y | Reserved for future use. |
| FUNC_PATH | CLOB (2K) | Y | Reserved for future use. |
| DEFAULT | CLOB (64K) | Y | Reserved for future use. |
| ENVSTRINGUNITS | VARCHAR (11) | Default string units when the object was created. |