Testing and debugging an application program on Db2 for z/OS®
Depending on the situation, testing your application program
might involve setting up a test environment, testing SQL statements,
debugging your programs, and reading output from the precompiler.
Designing a test data structure Db2 data, you should have Db2 data available for testing. To do this, you can create test tables and views.Populating the test tables with data Methods for testing SQL statements Executing SQL by using SPUFI Testing an external user-defined function Debugging stored procedures Debugging an application program Finding a violated referential or check constraint