SYSXMLTYPMSCHEMA catalog table
The SYSXMLTYPMSCHEMA table contains the XML schema information for an XML type modifier. It contains one row per XML schema for an XML type modifier. The schema is SYSIBM.
| Column name | Data type | Description | Use |
|---|---|---|---|
XML_TYPEMOD
_ID |
INTEGER
NOT NULL |
The id for the XML type modifier. | G |
| XSROBJECTID | INTEGER
NOT NULL |
The id for an XML schema registered in XSR. | G |
ELEMENT_
NAMESPACE |
INTEGER
NOT NULL |
String id for the namespace name of the root element node. By default, it is the TARGETNAMESPACE of the XML schema. It would be 0 if it is NO NAMESPACE. | G |
ELEMENT_
NAME |
INTEGER
NOT NULL |
String id for the local name of the root element node. It would be 0 if it is not specified. | G |
| CREATEDTS | TIMESTAMP
NOT NULL |
The timestamp when this type modifier is created. | G |
| ALTEREDTS | TIMESTAMP
NOT NULL |
The timestamp when this type modifier is altered | 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 |
| 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 |