Search found 1 match
- Wed Aug 11, 2010 2:29 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Continue Error handler in Stored Procedure stage
- Replies: 0
- Views: 486
Continue Error handler in Stored Procedure stage
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 wa...