Data Transformation Engine Database Interface Designer Reference Guide

Chapter 10 - Debugging and Viewing Results Database Trace Files
Database Interface Designer Reference Guide
148
Producing the Database Trace During Map Execution
There are several different ways to enable the database trace for reporting
database-related information during map execution as discussed in the following
sections:
♦ Using the Trace adapter command (
-TRACE)
♦ Source usage:
! for a valid source
! for a source with errors
♦ Target usage:
! for a valid target
! for a target with a missing required value
! for a target using the Bad Data adapter command (
-BADDATA)
! for a target with
-UPDATE off
! for a target using the
DBLOOKUP/DBQUERY functions
Using the Trace Adapter Command (-TRACE)
To produce database trace information for specific database data sources or
targets, use the Trace adapter command (
–TRACE). For information about the
syntax of this command, refer to the Resource Adapters Reference Guide.
Note To produce the database trace file when using the DBQUERY or DBLOOKUP functions,
use the Syntax2 format to call the function. For example, if output card 3 contains a
DBLOOKUP function, call the function as
DBLOOKUP ( "SELECT …", "-DBTYPE DB2 -SOURCE LAMBIN –USER ARL97IN -TRACE").