How about scanning the $stdlist for the current job looking for the string
"maximum number of records". I think you'll find the necessary stuff in the
archives to determine the spoolid of a job and suggestions for scanning it.
Make it a command file and xeq it after every Quiz if you like!

> -----Original Message-----
> From: Patrick Reid [SMTP:[log in to unmask]]
> Sent: Wednesday, October 10, 2001 7:17 PM
> To:   [log in to unmask]
> Subject:      Re: Powerhouse Question
>
> Thanks Tony.
>
>
> For Warnings that is not true. I did a SHOWJCW and SHOWVAR @ on both a
> good
> run and a bad run. They were identical.
>
> I know this has been brought up before. I checked the archives, but I have
> seen no real answer. I was hoping someone has come up with a creative
> solution.
>
> Thanks,
> Patrick
>
> "Tony Gil" <[log in to unmask]> wrote in message
> news:9q2ab4014v5@enews2.newsguy.com...
> > Yes!
> >
> > I ran into a similar situation and here's what I found. Whenever a
> COGNOS
> > application is called (QUIZ, QUICK, QTP, etc.), there are several JCW's
> set
> > by POWERHOUSE including 'QUIZ', 'QTP' and 'CJCW'. The CJCW is the one I
> use
> > to use to check for *E or errors. I believe there is a unique value for
> *W
> > or warnings as well.
> >
> > Tony Gil
> > Programmer/Analyst
> > Centis Inc.
> > 205 S. Puente Street
> > Brea, CA. 92821
> > v:   714-626-2406
> > f:   714-441-4536
> > e: [log in to unmask] <mailto:[log in to unmask]>
> >
> >
> >         -----Original Message-----
> >         From:   Patrick Reid [SMTP:[log in to unmask]]
> >         Sent:   Wednesday, October 10, 2001 1:46 PM
> >         To:     [log in to unmask]
> >         Subject:        [HP3000-L] Powerhouse Question
> >
> >         Ok all you Powerhouse Gurus, I need you help, Please.
> >
> >         Does anyone know of a way to make a job abort if Powerhouse Quiz
> > gets this
> >         error:
> >         *W* The maximum number of records has been selected?
> >
> >         I have figured out a way if it produces a subfile, but can not
> see
> a
> > way
> >         when it produces a disc file. Cognos recommended I run QTP
> first,
> > but we
> >         have to many programs to implement this and I don't believe it
> would
> > work
> >         for disc files anyway.
> >
> >         Any help would be greatly welcomed!
> >
> >         Thanks in advance,
> >         Patrick
> >
> >         This is what I have come up with for subfiles.
> >         !  CONTINUE
> >         !  LISTF xxx1500D
> >         !    IF CIERROR<>907 THEN
> >         !
> >         !      SETVAR EOFRECS FINFO("xxx1500D",19)
> >         !      SETVAR FLIMNUM FINFO("xxx1500D",12)
> >         !
> >         !      CONTINUE
> >         !      IF EOFRECS = FLIMNUM THEN
> >         !        SETJCW JCW=FATAL
> >         !      ENDIF
> >         !
> >         !    ENDIF
> >
>

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *