Continue Error handler in Stored Procedure stage
Posted: Wed Aug 11, 2010 2:29 pm
Hi,
I am using stored procedure stage to execute DB2 pocedure and this procedure will insert rows in to table based on some rules.
Procedure returns SQLSTATE='0' when it success or 'nonzero value' when it fails to insert rows and when return status is nonzero my job is getting abort. Is there any way to handle all nonzero values and my job needs to success irrespective of return status.
Example:
I have 10 rows needs to insert in to table by calling above job.
First row got inserted successfully with SQLSTATE '0'
Second row got rejected due to Data truncate with SQLSTATE='01004' ( Due to this job getting abort)
I want the job to be continue and load remaining rows with out abort.
I am using stored procedure stage to execute DB2 pocedure and this procedure will insert rows in to table based on some rules.
Procedure returns SQLSTATE='0' when it success or 'nonzero value' when it fails to insert rows and when return status is nonzero my job is getting abort. Is there any way to handle all nonzero values and my job needs to success irrespective of return status.
Example:
I have 10 rows needs to insert in to table by calling above job.
First row got inserted successfully with SQLSTATE '0'
Second row got rejected due to Data truncate with SQLSTATE='01004' ( Due to this job getting abort)
I want the job to be continue and load remaining rows with out abort.