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.