Page 1 of 1

Use Stored Procedure to call db2 sp

Posted: Fri Jul 27, 2012 12:42 am
by dongyingying
Hi All , when I create a parallel job use stored procedure stage to call a db2 sp ,when the sp failed caused by some exceptions or error ,but the job executed is ok ,this should been happend ,is that right ? how can I changed the job to make sure the job failed ?

Thanks I am Ethan msg from china.

Re: Use Stored Procedure to call db2 sp

Posted: Fri Jul 27, 2012 12:52 am
by ArndW
dongyingying wrote:......when the sp failed caused by some exceptions or error...
Please post those messages, otherwise anyone responding would just have to guess what them might be.

Posted: Fri Jul 27, 2012 5:11 pm
by ray.wurlod
There is probably a property you can set in the stage called something like "treat warnings as fatal". This would force the job to abort.