IBM Books

XML Extender Administration and Programming


Diagnostic information

All embedded SQL statements in your program and DB2 command line interface (CLI) calls in your program, including those that invoke the DB2 XML Extender user-defined functions (UDFs), generate codes that indicate whether the embedded SQL statement or DB2 CLI call executed successfully.

Your program can retrieve information that supplements these codes. This includes SQLSTATE information and error messages. You can use this diagnostic information to isolate and fix problems in your program.

Occasionally the source of a problem cannot be easily diagnosed. In these cases, you might need to provide information to your Software Support provider to isolate and fix the problem. The XML Extender includes a trace facility that records the XML Extender activity. The trace information can be valuable input to IBM Software Support. You should use the trace facility only under instruction from IBM Software Support.

This chapter describes how to access this diagnostic information. It describes:

It also lists and describes the SQLSTATE codes and error messages that the XML Extender might return.


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