XSROBJECTS table
The XSROBJECTS table contains one row for each registered XML schema. The schema is SYSIBM.
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 |
|---|---|---|---|
| XSROBJECTID | INTEGER
NOT NULL |
Internal identifier of the XML schema. XSROBJECTID is generated as an identity column. | G |
| XSROBJECTSCHEMA | VARCHAR(128)
NOT NULL |
Qualifier of the XML schema name. This is always set to 'SYSXSR'. | G |
| XSROBJECTNAME | VARCHAR(128)
NOT NULL |
Name of the XML schema. | 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 |
| GRAMMAR | BLOB(250M)
|
The internal binary representation of the XML schema. | G |
| PROPERTIES | BLOB(5M)
|
Additional property information of the entire XML schema. | G |
| CREATEDBY | VARCHAR(128)
NOT NULL |
Authorization ID under which the XML schema was created. | G |
| CREATEDTS | TIMESTAMP
NOT NULL |
The time that the Db2-supplied stored procedure XSR_REGISTER was executed for the XML schema. | 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 |
| CHAR(1)
|
Not used. |
N | |
| VARCHAR(128)
|
Not used. |
N | |
| REMARKS | VARCHAR(762)
|
Character string that contains comments about this XML schema. | G |