Director Log Database SQL Response
Moderators: chulett, rschirm, roy
Director Log Database SQL Response
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"
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.