Error Handling in Datastage
Posted: Fri Jul 29, 2005 8:05 am
Hi !
I am developing a datastage job which will read from Flat files and database tables, do lookups and then populate the target.
The logic and the Reject row handling (lookup not found) is already in place.
I was wondering if I could capture possible errors like File not available, File cannot be read, data type mismatch, Constraint violated, database connection errors etc.
I know that we can do that in the job sequencing bit, after the Job aborts/completes with the error, by reading into Datastage logs.
What i was wondering is whether we can handle these errors in the Job itself.
Regards
Nagesh
I am developing a datastage job which will read from Flat files and database tables, do lookups and then populate the target.
The logic and the Reject row handling (lookup not found) is already in place.
I was wondering if I could capture possible errors like File not available, File cannot be read, data type mismatch, Constraint violated, database connection errors etc.
I know that we can do that in the job sequencing bit, after the Job aborts/completes with the error, by reading into Datastage logs.
What i was wondering is whether we can handle these errors in the Job itself.
Regards
Nagesh