A tabela SYSXMLRELS contém uma linha para cada tabela XML criada para uma coluna XML.
O esquema é SYSIBM.
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 came from the basic machine-readable material (MRM) tape.
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 |
