Debugging Db2 stored procedures

A Db2® stored procedure is a compiled high-level language (HLL) program that can run SQL statements. z/OS® Debugger can debug any stored procedure written in assembler (if the program type is MAIN), C, C++, COBOL, and PL/I in any of the following debugging modes:

  • remote debug mode
  • full-screen mode using the Terminal Interface Manager
  • batch mode

Before you begin, verify that you have completed all the tasks described in Preparing a Db2 stored procedures program. The program resides in an address space that is separate from the calling program. The stored procedure can be called by another application or a tool such as the IBM® Db2 Development Center.

Refer to the following topics for more information related to the material discussed in this topic.