Red Hat Linux DB2 V 8.1

We have a scheduled DB2 job that runs a stored procedure. The command for the job is below (syntax error is not important-the real error is in the stored procedure).

connect to database MYDB;
Execute MYSTOREDPROC(1);
Connect reset;

1 st and third lines run successfully but the ' Execute MYSTOREDPROC(1);' step gives error. When we look at the Journal or the output log file, we see 'Succeded' message. How could this be ? SHouldn't it say the job failed ?

Thanks.

In the task center, have you checked the 'Stop execution at first return code that is a failure' in the Run properties tabpage for that task?