XSR_COMPLETE stored procedure

The XSR_COMPLETE procedure is the final stored procedure to be called as part of the XML schema registration process, which registers XML schemas with the XSR.

An XML schema is not available for validation until the schema registration completes through a call to this stored procedure.

Environment for XSR_COMPLETE

XSR_COMPLETE requires a WLM-established stored procedures address space that is configured for running Java™ routines.

Recommendation: Use WLM environment DSNWLM_JAVA for running XSR_COMPLETE. The startup procedure for this environment, DSNWLMJ, can be configured during installation, using installation panel DSNTIPRH, XML schema processing routines.

Before you can run the XSR_COMPLETE stored procedure in a Java 8 or later 64-bit JVM, you need to modify the WLM application environment. See Moving from 31-bit Java routines to 64-bit Java routines for instructions.

Note:

For compatibility with IBM® Semeru Runtime® for z/OS®, version 17 or later, the XSR_COMPLETE stored procedure requires a toleration APAR, PH58678 and z/OS 3.1 with APAR OA65253, or later.

Authorization required for XSR_COMPLETE

The user ID of the caller of the procedure must have the EXECUTE privilege on the XSR_COMPLETE stored procedure.

XSR_COMPLETE syntax diagram

The following syntax diagram shows the CALL statement for invoking XSR_COMPLETE.

rschema: An input parameter of type VARCHAR (128) that specifies the SQL schema part of the qualified name that identifies the XML schema in the XSR. If a non-null value is specified, it must be SYSXSR. If rschema is a null value, the default SQL schema SYSXSR is used.
name: An input parameter of type VARCHAR(128) that specifies the name of the XML schema. The complete qualified name for the XML schema is rschema.name, and it should be unique among all objects in the XSR. If a null value is specified, a unique value is generated and stored within the XSR. Rules for valid characters and delimiters that apply to any SQL identifier also apply to name.
schema-properties: An input parameter of type BLOB(5M) that specifies properties, associated with the XML schema. The argument can be an XML document that represents properties for the XML schema, or a null value.
for-decomposition: This value must be 0. XML schema decomposition is not supported.

Example of XSR_COMPLETE

The following example calls the XSR_COMPLETE stored procedure:

   CALL SYSPROC.XSR_COMPLETE(
     'SYSXSR',
     'POschema',
     :schemaproperty_host_var,
     0)

In this example, XSR_COMPLETE folds the name POschema to uppercase, so the name of the XML schema for which registration is completed is POSCHEMA. If you do not want XSR_COMPLETE to fold POschema to uppercase, you need to delimit the name with double quotation marks ("), as in the following example.

   CALL SYSPROC.XSR_COMPLETE(
     'SYSXSR',
     '"POschema"',
     :schemaproperty_host_var,
     0)