More detailed error messages?
Posted: Mon May 17, 2004 10:11 am
I have a simple job that reads from one table and writes to another table. Both tables are SQL Server tables and I am using an ODBC stage to make the connection. Some of the records are failing to insert but when I view the log the only error messages are SQLExecute failed ... 0 rows affected. I run the same insert through Query Analyzer and I get a more detailed message telling me what is actually wrong.
Is there a setting or another log that I can view using DataStage that I can see more detailed messages that tell me what is actually wrong when a statement fails?
Is there a setting or another log that I can view using DataStage that I can see more detailed messages that tell me what is actually wrong when a statement fails?