XSROBJECTS

The XSROBJECTS table contains one row for each registered XML schema.

The following table describes the columns in the XSROBJECTS table:

Table 1. 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: C Complete I Incomplete
DECOMPOSITION	DECOMP	CHAR(1) Nullable	Indicates the decomposition status of the XSR object: Y Enabled N Not enabled
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.