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. |