SYSXMLTYPMOD catalog table

The SYSXMLTYPMOD table contains rows about the XML type modifiers of XML columns. Rows in this table can be inserted, updated and deleted. The schema is SYSIBM.

Table 1. SYSIBM.SYSXMLTYPMOD table column descriptions
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.
Y
WITH type annotation
N
with no 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 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
CREATEDBY
VARCHAR(128)
NOT NULL
 Primary authorization ID of the user who created the database. G