Director Log Database SQL Response

gsbrown · Post by **gsbrown** » Fri Apr 20, 2012 1:52 pm

I have a job with an ODBC stage that is submitting a user-defined INSERT INTO...SELECT FROM statement. Is there a way to capture the response from the database and write it to the DataStage job log? For example, "17,000 Row(s) affected"

ketfos · Post by **ketfos** » Sun Apr 22, 2012 8:14 pm

Where do you see the text "17,000 Row(s) affected" ?

ray.wurlod · Post by **ray.wurlod** » Sun Apr 22, 2012 8:29 pm

I think the problem is that this message, which is generated by the database server, is not appearing in the log, but gsbrown would like to see it there.

I don't have an answer for this one, but might suggest you investigate environment variables that control what is emitted by the database. These will be database environment variables rather than DataStage environment variables.