Continue Error handler in Stored Procedure stage

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
p499349
Participant
Posts: 1
Joined: Mon Aug 09, 2010 1:17 pm

Continue Error handler in Stored Procedure stage

Post by p499349 »

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.
Thanks
Kiran
Post Reply