A tabela SYSXMLTYPMOD contém linhas sobre os modificadores de tipo XML de colunas XML.
As linhas nesta tabela podem ser inseridas, atualizadas e excluídas.
O esquema é SYSIBM.
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.
| 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 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 |
