Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2004

    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;
    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 ?


  2. #2
    Join Date
    Mar 2006
    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?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts