Debugging Procedures

The following techniques can help you debug your SQL-invoked external routines:
idmscu
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)
 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 IDMSIN01_ONLY in conjunction with SQLTRACE=ON to trace a single transaction. 
  • 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)
     You enable SQL-invoked external routine tracing by including the following parameters in the SYSIDMS file:
    SQLTRACE=ON or DMLTRACE=ON PROCTRACE=ON