IBM Books

XML Extender Administration and Programming


XML Extender stored procedures

The XML Extender provides stored procedures for administration and management of XML columns and collections. These stored procedures can be called from the DB2 client. The client interface can be embedded in SQL, ODBC, or JDBC. Refer to the section on stored procedures in the DB2 UDB Administration Guide for details on how to call stored procedures.

The stored procedures use the prefix db2xml, which is the schema name of the XML Extender

The XML Extender provides three types of stored procedures:

The size parameter, UDB_SIZE

The XML Extender stored procedure syntax uses the parameter UDB_SIZE to specify the size of certain character parameters. The value of UDB_SIZE is determined by the version of DB2 UDB that is running. The following list shows the field size values for the different DB2 UDB versions. Use the correct value when declaring XML Extender stored procedures.
DB2 UDB version Size
6.1 32
7.1 64


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]