Unanswered: Success message instead of Error message
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;
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 ?