----------
> From: Rudderow, Evan <[log in to unmask]>
> To: [log in to unmask]
> Subject: Powerhouse question
> Date: Wednesday, October 02, 1996 4:00 PM
>
> Hi all,
>
> Every one in a while we have a problem with jobs using Powerhouse,
> specifically they encounter some kind of severe error -- like a full data
> set -- which ought to cause the remainder of the job to flush.  Of course
> the UDCs for QUICK, QUIZ, QTP, etc. as distributed by Cognos have a
CONTINUE
> statement just before the RUN statement, so the jobs don't flush.
>
> Have any of you modified the Cognos UDCs to remove the CONTINUE
statements?
>  Did doing so break anything?
>
> TIA
>
>  -- Evan


Hi Evan,

I don't think it's a good idea to change the PowerHouse UDCs. They're
pretty involved.

QUIZ and QTP both set JCWs when they are run. In a job, we generally only
care about QTP blowing up, since QUIZ can't change data. We do the
following check after each QTP run in a job:

IF QTP <> 0 OR CJCW <> 0 THEN
  ESCAPE
ENDIF

Testing for just the JCW 'QTP' or 'QUIZ' used to work until 7.29, when some
jobs fell thru the cracks because they didn't set those JCWs, but were
setting the 'CJCW' instead, so we had to test that one also.

Hope this helps.

Lou Cook
Northwest Textbook Depository