SYSXMLRELS catalog table
The SYSXMLRELS table contains one row for each XML table that is created for an XML column. The schema is SYSIBM.
| Column name | Data type | Description | Use |
|---|---|---|---|
| TBOWNER | VARCHAR(128)
NOT NULL |
Schema or qualifier of the base table. | G |
| TBNAME | VARCHAR(128)
NOT NULL |
Name of the base table. | G |
| COLNAME | VARCHAR(128)
NOT NULL |
Name of the XML column in the base table. | G |
| XMLTBOWNER | VARCHAR(128)
NOT NULL |
Schema or qualifier of the XML table. | G |
| XMLTBNAME | VARCHAR(128)
NOT NULL |
Name of the XML table. | G |
| XMLRELOBID | INTEGER
NOT NULL |
Internal identifier of the relationship between the base table and the XML table. | G |
| IBMREQD | CHAR(1)
NOT NULL |
A value of Y indicates that the row was provided with the Db2 product code. For all other values, see Release dependency indicators. The value in this field is not a reliable indicator of release dependencies. RELCREATED should be used instead. |
G |
| CREATEDTS | TIMESTAMP
NOT NULL |
Time when the XML table was created. | G |
| RELCREATED | CHAR(1)
NOT NULL |
The release of Db2 that is used to create the object. See Release dependency indicators for the values. | G |