IBM Books

XML Extender Administration and Programming


Calling XML Extenders stored procedures

In general, call the XML Extender using the following syntax:

CALL db2xml!function_entry_point 

Where:

db2xml
Specifies the library of XML Extender stored procedures. It is stored in the sqllib/function directory.

function_entry_point
Specifies the arguments passed to the stored procedure.

In the CALL statement, the arguments that are passed to the stored procedure must be host variables, not constants or expressions. The host variables can have null indicators. See samples for calling stored procedures in the DXX_INSTALL/samples/c and DXX_INSTALL/samples/cli directories, and in the following sections of this book: Composing the XML document and Managing XML collection data.

In the DXX_INSTALL/samples/c directory, SQC code files are provided to call XML collection stored procedures using embedded SQL. In the DXX_INSTALL/samples/cli directory, the sample files show how to call stored procedures using the Call Level Interface (CLI).


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