Testing and Debugging Stored Procedures

Testing and debugging a stored procedure is quite a bit different than teting other programs. There are different tools that can be used to help in this effort.

Testing a Stored Procedure

Some commonly used debugging tools, such as TSO TEST, are not available in the environment where stored procedures run. Here are some alternative testing strategies to consider.

Standalone Program on a Workstation

If you have debugging support on a workstationI (such as with Stored Procedure Builder [SPB]; see Chapter 5), you might choose to do most of your development and testing on a workstation, before installing a stored procedure on MVS. This results in very little debugging activity on MVS.

Debug Tool and IBM VisualAge ...

Get DB2® Universal Database™ for OS/390™ v7.1 Application Certification Guide now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.