Data Transformation Engine Database Interface Designer Reference Guide

Chapter 10 - Debugging and Viewing Results Database Trace Files
Database Interface Designer Reference Guide
160
Query : SELECT FIRSTNAME, LASTNAME , EMAILADDR FROM EVENTMGT.MEMBERSHIP
WHERE MEMBERID = 'D191-0002'
Query size : 108
Output is to a buffer.
Statement execution succeeded.
The columns are of the following types:
Column 1 (FIRSTNAME) type is VARCHAR(30).
Column 2 (LASTNAME) type is VARCHAR(50).
Column 3 (EMAILADDR) type is VARCHAR(50).
Number of buffers in fetch array = 492
Writing results to a buffer.
Retrieved 1 records (42 bytes).
Size of DBQUERY data is 42.
The following data was returned from a DBQUERY:
Janet|Leverling|[e-mail]
.
.
In this example, as in the previous one, the database trace file reports the actual
query to be executed. In this example, each
DBQUERY returns a single row
containing the three columns from the Membership table for the specified
MEMBERID. The data returned by the
DBQUERY function conforms to the
Delimited Row group format type tree definition, meaning that there will be a
pipe character (|) delimiter between columns and a carriage return/line feed
terminator for each row of data.
The size of the data returned by the
DBQUERY is also listed. Note that the size of
the
DBQUERY data is specified as 42. This value represents the length of the data,
including the carriage return/line feed that follows the row of data. There will be a
similar set of entries in the database trace file for each
DBQUERY executed.
Tracing Database Errors Only
Depending upon the number of database sources and targets, the volume of
database functions that are executed, and the database trace settings that are
used, the database trace file can contain a large amount of data. Even when no
database errors occur, the database trace file can become very large.
Use the Trace Error adapter command (
-TRACEERR) to minimize the amount of
information contained in the database trace file (map_name.dbl). This file contains
only the database errors occurring during the map execution.
When
-TRACEERR is specified, the database trace file is produced using the full
name of the .mdq with a .dbl file name extension instead of the usual trace (.mtr)
extension. It is created in the directory in which the map is located. Use the
-TRACEERR filename syntax as described in the Resource Adapters Reference
Guide to specify the name for the database trace file.