DSXchange

Hi

I use ODBC Stage to get the data from DB2. I would like to see the SQL which is sent to the database from DataStage in my job logfile. How do I do that ?

Also, how do we know what SQL has got executed in the database.
I know we can look at view SQL tab to see the SQL which is been sent to database. but how do we know if thats what is getting executed exactly in the database. Otherwords how do we know if the database is not dropping something or converting something in the Database when the query is executed...

Thanks

1. On the Tracing tab select all options except "report row data".

2. Have your DBA monitor what's executed.

DataStage uses "prepared SQL".

I did select all options in tracing tab except REPORT ROW DATA and still it does not show me the SQL sent to DataBase in the Job Log.

Am I Missing something here ?

Thanks

Yes, my bad. The trace goes into a trace file; a file in the &PH& directory in your project. The file name ends in "Trace".

So there is no way we can see the SQL in the job log in Director ?

Thanks

The job log logs what the job does. The Link Report entries will normally show the SQL that DataStage sends. As far as I am aware DataStage has no mechanism to capture any "translation" that might be done by an ODBC driver, database client software or database server.