A tabela SYSXMLTYPMSCHEMA contém as informações do esquema XML para um modificador de tipo XML.
Ele contém uma linha por esquema XML para um modificador de tipo XML.
O esquema é SYSIBM.
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 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 |
