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.