Data Transformation Engine Database Interface Designer Reference Guide

Chapter 10 - Debugging and Viewing Results Database Trace Files
Database Interface Designer Reference Guide
162
Output is to a buffer.
Statement execution succeeded.
The columns are of the following types:
Column 1 (pub_id) type is char(4).
Column 2 (pub_name) type is varchar(40).
Column 3 (city) type is varchar(20).
Column 4 (state) type is varchar(2).
Column 5 (country) type is varchar(30).
Number of buffers in fetch array = 1
Writing results to a buffer.
Retrieved 8 records (305 bytes).
Status returned to engine: (0) Success
Database type is MS SQL Server
Status returned to engine: (0) Success
Interface library version 6.0(140)
Data being retrieved for input card 3.
Database adapter version 6.0(140)
Starting a database unload...
Server\\Database: HP_NT\\pubs
Userid : sa
Password :
Query : SELECT * FROM Title
Query size : 19
Output is to a buffer.
Error in: dbsqlexec
Error : 208
State : 1
Message : Invalid object name 'Title'.
Error in: dbsqlexec
Error : 10007
Message : General SQL Server error: Check messages from the SQL Server.
Failed to execute statement.
Invalid object name 'Title'.
Retrieved 0 records (0 bytes).
Error returned to engine: (-9) Failed to execute the SQL statement
Cleaning up and closing the transaction...
The transaction was successfully committed.
A transaction was started.
Status returned to engine: (0) Success
After reviewing this file, notice that the query for input card number 3 (SELECT *
FROM Title) failed because it references an object name (the table name Title)
that does not exist. Alternatively, you could use the Trace Error adapter command
(
-TRACEERR) for each of the three input cards and produce the following database
trace file:
Invalid object name 'Title'.
This file can be used along with the following execution audit log information:
<SourceReport card="1" adapter="DB" bytes="1810" adapterreturn="0">
<Message>Success</Message>
<TimeStamp>01:02:00 July 9, 2001</TimeStamp>
</SourceReport>
<SourceReport card="2" adapter="DB" bytes="305" adapterreturn="0">
<Message>Success</Message>