CMDTRACE

Valid For

Extract and Replicat

Description

Use the CMDTRACE parameter to display macro expansion steps in the report file. You can use this parameter more than once in the parameter file to set different options for different macros.

Default

OFF

Syntax

CMDTRACE [ON | OFF | DETAIL]

ON

Enables the display of macro expansion.

OFF

Disables the display of macro expansion.

DETAIL

Produces a verbose display of macro expansion.

Example

In the following example, tracing is enabled before #testmac is invoked, and then disabled after the macro’s execution.

MACRO #testmac
BEGIN
col1 = col2,
col3 = col4
END;
...
CMDTRACE ON
MAP test.table2 , TARGET test.table2,
COLMAP (#testmac);
CMDTRACE OFF