EXPTRACE

The EXPTRACE option controls whether system DML programs are traced when the PRGTRACE option is set to YES. The EXPTRACE option can be set to YES to help debug a user-defined program that calls system programs.

Data type

BOOLEAN

Syntax

EXPTRACE = {YES|NO}

Arguments

YES: All programs are traced, including system DML programs.
NO: System DML programs are not traced. Only programs other than system DML programs are traced.

Notes

How to Identify System DML Programs

Some OLAP DML statements are implemented as system DML programs. To send to the current outfile a list of system DML programs affected by EXPTRACE, issue the following statement.

SHOW AW(PROGRAM 'express')

Examples

Example 12-4 Tracing System DML Programs

After the following statements are issued, system DML programs such as LISTNAMES and ALLSTAT are traced in addition to user-defined programs.

PRGTRACE = YES
EXPTRACE = YES