Hi,
I would like to know that when we use the "After/Before SQL" property in DB2 connector, dont we get the status of SQL query in the director logs??
I have searched this in the 'Search' but no success.
The problem is I have used this property in one of my job; the job and the query executed successfully but there is nothing related to the successful execution of the SQL Query in the director logs. Am I missing something, somewhere in the job ??
Right now I have to manually check the data in the table to see if the query executed successfully.
Using "After SQL" property in DB2 Connector
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 353
- Joined: Mon Jan 17, 2011 5:03 am
- Location: Mumbai, India
Using "After SQL" property in DB2 Connector
Thanx and Regards,
ETL User
ETL User
-
- Premium Member
- Posts: 353
- Joined: Mon Jan 17, 2011 5:03 am
- Location: Mumbai, India
If I set "Fail on error" to yes then my job will fail if an error occurs in the execution of the SQL. But that is not my requirement.
I want when the Query executes successfully and my job too, it should be reflected in the director logs. The director logs does not have anything related to the successfull execution of the Query.
I want when the Query executes successfully and my job too, it should be reflected in the director logs. The director logs does not have anything related to the successfull execution of the Query.
Thanx and Regards,
ETL User
ETL User
I just tried running an erratic SQL-Statement (select on a missing table) as a Before-SQL from DB2-Connector with "Fail on error" set to "No".
This results in a warning in the director-log. Success is reported in Unix-Style: no news is good news.
This results in a warning in the director-log. Success is reported in Unix-Style: no news is good news.
"It is not the lucky ones are grateful.
There are the grateful those are happy." Francis Bacon
There are the grateful those are happy." Francis Bacon