
The XSROBJECTS table contains one row for each registered XML schema.
The following table describes the columns in the XSROBJECTS table:
| Column name | System Column Name | Data Type | Description |
|---|---|---|---|
| XSROBJECTID | OBJECTID | BIGINT | Internal identifier of the XML schema. |
| XSROBJECTSCHEMA | XSRSCHEMA | VARCHAR(128) | Qualifier of the XML schema name. |
| XSROBJECTNAME | XSRNAME | VARCHAR(128) | Name of the XML schema |
| SYSTEM_XSR_SCHEMA | SYSXSCHEMA | CHAR(10) | System library name corresponding to the qualifier of the XML schema. |
| SYSTEM_XSR_NAME | SYSXNAME | CHAR(10) | System name of the XSROBJECT that correlates to the XML schema. |
| TARGETNAMESPACE | TGTNAMESPC | VARCHAR(1000) Nullable |
String identifier for the target namespace. |
| SCHEMALOCATION | SCHEMALOC | VARCHAR(1000) Nullable |
String identifier for the schema location. |
| XSR_OBJECT_TEXT | LABEL | VARGRAPHIC(50) CCSID 1200 Nullable |
A character string supplied with
the LABEL statement. Contains the null value if there is no label. |
| GRAMMAR | GRAMMAR | BLOB(250M) Nullable |
The internal binary representation of the XML schema as the result of an XML_COMPLETE. |
| PROPERTIES | PROPERTIES | BLOB(5M) Nullable |
Additional document property information for the XML schema document. |
| XSR_SCHEMA_DEFINER | DEFINER | VARCHAR(128) | Authorization ID under which the XML schema was created. |
| XSR_SCHEMA_OWNER | OWNER | VARCHAR(128) | Authorization ID that owns the XML schema. |
| XSR_SCHEMA_CREATED | CREATEDTS | TIMESTAMP | The time when the XML schema document was registered. |
| STATUS | STATUS | CHAR(1) | Registration status of the XML schema:
|
| DECOMPOSITION | DECOMP | CHAR(1) Nullable |
Indicates the decomposition status
of the XSR object:
|
| VERSION | VERSION | VARCHAR(128) Nullable |
Indicates the version used during decomposition. |
| IASP_NUMBER | IASPNUMBER | SMALLINT | Indicates the IASP where the catalog table is located. |
| LONG_COMMENT | REMARKS | VARGRAPHIC(2000) CCSID 1200 Nullable |
A character string supplied with
the COMMENT statement. Contains the null value if there is no long comment. |
