Debugging Procedures

The following techniques can help you debug your SQL-invoked external routines:

Use WRITE TO LOG or SNAP requests to display trace information and key data structures to the log (available under DC/UCF only).
Use COBOL or PL/I DISPLAY statements or write messages to a print file (available under local mode or with LE/370 support under DC)
Note: If the program uses a VS COBOL compiler, even in local mode, you cannot use:
- DISPLAY statements
- STATE and FLOW compiler options
Use SQLTRACE and DMLTRACE SYSIDMS parameters to trace the database calls made by the SQL-invoked external routine (available under local mode only).
Use PROCTRACE in conjunction with SQLTRACE or DMLTRACE to trace the calls made into and out of the SQL-invoked external routine. This option displays the parameters both before and after the call (available under local mode only)
Note: You enable SQL-invoked external routine tracing by including the following parameters in the SYSIDMS file:
```
 SQLTRACE=ON or DMLTRACE=ON
 PROCTRACE=ON
```