XSROBJECTCOMPONENTS table
The XSROBJECTCOMPONENTS table contains one row for each component (document) in an XML schema. The schema is SYIBM.
Rows in this table can only be changed using static SQL statements issued by the Db2-supplied XSR stored procedures.
| Column name | Data type | Description | Use |
|---|---|---|---|
| XSRCOMPONENTID | INTEGER
NOT NULL |
Internal identifier of the XML schema document. XSRCOMPONENTID is generated as an identity column. | G |
| TARGETNAMESPACE | INTEGER
|
The value of the STRINGID column in SYSIBM.SYSXMLSTRINGS when the target namespace URI of the primary XML schema document is stored in SYSIBM.SYSXMLSTRINGS. | G |
| SCHEMALOCATION | INTEGER
|
The value of the STRINGID column in SYSIBM.SYSXMLSTRINGS when the schema location URI of the primary XML schema document is stored in SYSIBM.SYSXMLSTRINGS. | G |
| ROWID | ROWID
NOT NULL GENERATED ALWAYS |
The ID that is used to support BLOB data type values. | G |
| COMPONENT | BLOB(30M)
NOT NULL |
Contents of the XML schema document. | G |
| PROPERTIES | BLOB(5M)
|
If available, additional property information of the XML schema document | G |
| CREATEDTS | TIMESTAMP
NOT NULL |
The time that the XML schema document was registered. | G |
| STATUS | CHAR(1)
NOT NULL WITH DEFAULT |
Registration status of the XML schema:
|
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 |