DB2 Version 9.7 for Linux, UNIX, and Windows

SYSCAT.XSROBJECTS catalog view

Each row represents an XML schema repository object.

Table 1. SYSCAT.XSROBJECTS Catalog View
Column Name Data Type Nullable Description
OBJECTID BIGINT   Unique generated identifier for an XSR object.
OBJECTSCHEMA VARCHAR (128)   Schema name of the XSR object.
OBJECTNAME VARCHAR (128)   Unqualified name of the XSR object.
TARGETNAMESPACE VARCHAR (1001) Y String identifier for the target namespace, or public identifier.
SCHEMALOCATION VARCHAR (1001) Y String identifier for the schema location, or system identifier.
OBJECTINFO XML Y Metadata document.
OBJECTTYPE CHAR (1)   XSR object type.
  • D = DTD
  • E = External entity
  • S = XML schema
OWNER VARCHAR (128)   Authorization ID of the owner of the XSR object.
OWNERTYPE CHAR (1)  
  • S = The owner is the system
  • U = The owner is an individual user
CREATE_TIME TIMESTAMP   Time at which the object was registered.
ALTER_TIME TIMESTAMP   Time at which the object was last updated (replaced).
STATUS CHAR (1)   Registration status.
  • C = Complete
  • I = Incomplete
  • R = Replace
  • T = Temporary
DECOMPOSITION CHAR (1)   Indicates whether or not decomposition (shredding) is enabled on this XSR object.
  • N = Not enabled
  • X = Inoperative
  • Y = Enabled
REMARKS VARCHAR (254) Y User-provided comments, or the null value.