Data Transformation Engine Database Interface Designer Reference Guide

Chapter 10 - Debugging and Viewing Results Database Trace Files
Database Interface Designer Reference Guide
149
Database Trace for a Valid Source
To produce the following database trace file example, we want to produce a
database trace for input card 2 (which is a database). To do this, you must include
the Trace adapter command (
-TRACE) in the GET > Source > Command setting.
Upon execution, database trace information is generated for input card 2; the
example follows.
Note Line numbers are for reference purposes only.
01 Database type is Oracle
02 Status returned to engine: (0) Success
03 No existing connection was found.
04 Connection to Oracle has been established.
05 Interface library version 6.0(140)
06 Data being retrieved for input card 2.
07 Database adapter version 6.0(140)
08 Starting a database unload...
09 Host string:
10 Userid : demo
11 Password : ****
12 Query : SELECT I.*, P.LIST_PRICE, P.MIN_PRICE, P.START_DATE, P.END_DATE
13 FROM ITEM I, PRICE P, PRODUCT PR
14 WHERE I.PRODUCT_ID = P.PRODUCT_ID and PR.PRODUCT_ID = 15 I.PRODUCT_ID
15 ORDER BY PR.PRODUCT_ID
16 Query size : 189
17 Output is to a buffer.
18 Statement execution succeeded.
19 The columns are of the following types:
20 Column 1 (ORDER_ID) type is NUMBER(4).
21 Column 2 (ITEM_ID) type is NUMBER(4).
22 Column 3 (PRODUCT_ID) type is NUMBER(6).
23 Column 4 (ACTUAL_PRICE) type is NUMBER(8,2).
24 Column 5 (QUANTITY) type is NUMBER(8).
25 Column 6 (TOTAL) type is NUMBER(8,2).
26 Column 7 (LIST_PRICE) type is NUMBER(8,2).
27 Column 8 (MIN_PRICE) type is NUMBER(8,2).
28 Column 9 (START_DATE) type is DATE.
29 Column 10 (END_DATE) type is DATE.
30 Number of buffers in fetch array = 574
31 Writing results to a buffer.
32 Retrieved 543 records (34451 bytes).
33 Status returned to engine: (0) Success
34 Cleaning up and closing the transaction...
35 The transaction was successfully committed.
36 Status returned to engine: (0) Success
37 Commit was successful.
38 Database disconnect succeeded.