Description: Contains one row for each distinct type defined to the system.
Tablespace: SYSOBJ
Indexes(Fields):
DSNODX01(SCHEMA.NAME)
DSNODX02(DATATYPEID)
| Column name | Description | Data type |
|---|---|---|
| SCHEMA | Schema of the distinct type. | NOT NULL |
| OWNER | Owner of the distinct type. | NOT NULL |
| NAME | Name of the distinct type. | NOT NULL |
| CREATEDBY | Authorization ID under which the distinct type was created. | NOT NULL |
| SOURCESCHEMA | Schema of the source data type. | NOT NULL |
| SOURCETYPE | Name of the source type. | NOT NULL |
| METATYPE | The class of data type: ; T
|
NOT NULL |
| DATATYPEID | Internal identifier of the distinct type. | NOT NULL |
| SOURCETYPEID | Internal ID of the built-in data type upon which the distinct type is based. | NOT NULL |
| LENGTH | Maximum length or precision of a distinct type that is based on the IBM-defined DECIMAL data type. | NOT NULL |
| SCALE | Scale for a distinct type that is based on the IBM-defined DECIMAL type. For all other distinct types, the value is 0. | NOT NULL |
| SUBTYPE | Subtype of the distinct type, which is based on the subtype of the source type: ; B
|
NOT NULL |
| CREATEDTS | Time when the distinct type was created. | NOT NULL |
| ENCODING_SCHEME | Encoding scheme of the distinct type: ; A
|
NOT NULL |
| IBMREQD | A value of Y indicates that the row came from the basic machine-readable material (MRM) tape. | NOT NULL |
| REMARKS | A character string provided by the user with the COMMENT statement. | NOT NULL |
Adapted from material found in the IBM DB2 Universal Database for z/OS V8 SQL Reference (SC18-7426-02).