DB2 10.5 for Linux, UNIX, and Windows

Built-in procedures

A procedure is an application program that can be started through the SQL CALL statement. The procedure is specified by a procedure name, which may be followed by arguments that are enclosed within parentheses. Built-in procedures are procedures provided with the database manager.

This topic lists the supported built-in procedures for managing XML schema repository (XSR) objects. See Table 1.

There are additional built-in procedures documented under the following headings:

ADMIN_CMD procedure and associated SQL routines
Administrative task scheduler routines and views
Audit routines and procedures
Automatic maintenance SQL routines and views
Common SQL API stored procedures
Explain routines
Monitor routines
Snapshot SQL routines and views
SQL procedures SQL routines
Stepwise redistribute SQL routines
Storage management tool SQL routines
Text search SQL routines
Workload management routines
Miscellaneous SQL routines and views

For details about these additional built-in procedures, see Supported built-in SQL routines and views.

Table 1. XML schema repository procedures
Function	Description
XSR_ADDSCHEMADOC procedure	Add an XML schema document to an XML schema.
XSR_COMPLETE procedure	Complete the XML schema registration process for an XML schema.
XSR_DTD procedure	Register a document type declaration.
XSR_EXTENTITY procedure	Register an external entity.
XSR_REGISTER procedure	Register an XML schema.
XSR_UPDATE procedure	Update an existing XML schema.