SYSIBM.SYSXMLTYPMOD table
The SYSIBM.SYSXMLTYPMOD table contains rows about the XML type modifiers of XML columns. Rows in this table can be inserted, updated and deleted.
Column name | Data type | Description | Use |
---|---|---|---|
XML_TYPEMOD
_ID |
INTEGER
NOT NULL GENERATED ALWAYS AS IDENTITY |
An id generated for the XML type modifier, it is an identity column and primary key. | G |
TYPE_
ANNOTATION |
CHAR(1)
NOT NULL |
Indicate whether there is type annotation.
|
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 |
CREATEDBY | VARCHAR(128)
NOT NULL |
Primary authorization ID of the user who created the database. | G |