XSROBJECTHIERARCHIES table

The XSROBJECTHIERARCHIES table contains one row for each component (document) in an XML schema to record the XML schema document hierarchy relationship. The schema is SYSIBM.

Rows in this table can only be changed using static SQL statements issued by the Db2-supplied XSR stored procedures.

Table 1. SYSIBM.XSROBJECTHIERARCHIES table column descriptions
Column name Data type Description Use
XSROBJECTID
INTEGER
 Internal identifier of the XML schema. G
XSRCOMPONENTID
INTEGER
 Internal identifier of the XML schema document. G
HTYPE
CHAR(1)
 Hierarchy type:
D
Document
P
Primary document
 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
RELCREATED
CHAR(1)
NOT NULL
 The release of Db2 that is used to create the object. See Release dependency indicators for the values. G