Testing a user-defined function by using SQL INSERT statements

You can use SQL to insert debugging information into a Db2 table. This allows other machines in the network (such as workstations) to easily access the data in the table by using DRDA access.

About this task

Db2 discards the debugging information if the application executes the ROLLBACK statement. To prevent the loss of the debugging data, code the calling application so that it retrieves the diagnostic data before executing the ROLLBACK statement.