Originally posted by: SystemAdmin

I have an output card that writes something to a DB.
Right now it writes an error message to the trace file
-TE+ ..\..\Traces\xxxxx.dbl when something goes wrong,
but how can I get it to write the SQL statement that it is trying to execute ?
Thanks
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange

Originally posted by: SystemAdmin

Perhaps I'm stating the obvious, but, for debugging purposes, I usually add another output card to the map which outputs the SQL without executing it.
#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender

Originally posted by: SystemAdmin

Are you using the -BADDATA command? With this command it allows the map to continue, displays the SQL that is having a problem in the *.DBL and creates a file with the records that are causing the problem. I am also using just -T to create the .DBL not -TE, not sure if that makes a difference.
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender

Originally posted by: SystemAdmin

Hi
My thought was that I could just change the -TE to something else and that would give me the SQL statement in the tracefile.
I will try with that -T.
JDIVOKY, I have an output card using the Database adapter. It uses an DBQuery file to insert records into a table so I do not know how to get my hands on the SQL statement.

Thanks
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender
#DataExchange