Use Stored Procedure to call db2 sp

[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.

[ArndW]

......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.

[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.