Data Transformation Engine Database Interface Designer Reference Guide

Chapter 10 - Debugging and Viewing Results Database Trace Files
Database Interface Designer Reference Guide
153
♦ After the connection is made, the database trace shows the column definitions
for the output table.
♦ Next, the database trace file displays the actual SQL statements to be executed
using the data produced for the output card. Because update mode is enabled,
the database trace file displays both an INSERT statement and an UPDATE
statement. The UPDATE statement is executed for each row in the output for
which a corresponding row is found in the database table, using the update key
defined (which, in this example, is the MemberID column). The INSERT
statement is executed for all rows in the output for which a corresponding row
does not exist in the table.
♦ After the SQL statements in the sample, the database trace file indicates the
number of rows that were both inserted (5) and updated (2).
♦ Finally, the database trace file indicates that database load was executed
successfully (Database load complete) and that the database changes were
committed (The transaction was successfully committed).
Database Trace for a Target - Missing Required Value
The following database trace file example was produced by using almost the same
map as in the preceding example except for the usage of a different input data file.
This database trace file illustrates the information you might see if a database
error occurred while attempting to insert or update rows in a table.
Database type is Oracle
Status returned to engine: (0) Success
No existing connection was found.
Connection to Oracle has been established.
Interface library version 6.0(140)
Loading data for output card 1.
Database adapter version 6.0(140)
Starting database load...
Host string:
Userid : eventmgt
Password : ********
Update mode is on.
The columns are of the following types:
Column 1 (MEMBERID) type is VARCHAR(10).
Column 2 (FIRSTNAME) type is VARCHAR(30).
Column 3 (LASTNAME) type is VARCHAR(50).
Column 4 (TITLE) type is VARCHAR(50).
Column 5 (COMPANYNAME) type is VARCHAR(50).
Column 6 (ADDRESS) type is VARCHAR(255).
Column 7 (CITY) type is VARCHAR(50).
Column 8 (STATEORPROVINCE) type is VARCHAR(20).
Column 9 (POSTALCODE) type is VARCHAR(20).
Column 10 (COUNTRY) type is VARCHAR(50).
Column 11 (PHONENUMBER) type is VARCHAR(30).
Column 12 (FAXNUMBER) type is VARCHAR(30).
Column 13 (EMAILADDR) type is VARCHAR(50).
Column 14 (MEMBERSINCE) type is DATE.
The insert statement to be executed is: