Data Transformation Engine Database Interface Designer Reference Guide

Chapter 10 - Debugging and Viewing Results Database Trace Files
Database Interface Designer Reference Guide
159
Output is to a buffer.
Statement execution succeeded.
Retrieved 0 records (0 bytes).
Size of DBLOOKUP data is 0.
Warning returned to engine: (2) No data found
Cleaning up and closing the transaction...
.
.
The following SQL statement to be executed:
DELETE FROM REGISTRATION WHERE REGISTRATIONSTATUS = 'Overflow'
and the resulting successful execution statement:
Statement execution succeeded
are included in this trace file as shown in the example above. Note that no records
were retrieved because the DELETE statement does not return data.
The next series of statements are produced for an output card using a
DBQUERY
function to obtain several columns from a database table based upon specified
values in the MEMBERID column in the input data.
.
.
Starting a database unload...
Host string:
Userid : eventmgt
Password : ********
Query : SELECT FIRSTNAME, LASTNAME , EMAILADDR FROM EVENTMGT.MEMBERSHIP
WHERE MEMBERID = 'D191-0001'
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 (40 bytes).
Size of DBQUERY data is 40.
The following data was returned from a DBQUERY:
Nancy|Davolio|[e-mail]
Status returned to engine: (0) Success
Status returned to engine: (0) Success
Interface library version 6.0(140)
Data being retrieved for DBQUERY function.
Database adapter version 6.0(140)
Starting a database unload...
Host string:
Userid : eventmgt
Password : ********