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 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 |