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 * > > * To join/leave the list, search archives, change list settings, * > * etc., please visit http://raven.utc.edu/archives/hp3000-l.html * > * To join/leave the list, search archives, change list settings, * * etc., please visit http://raven.utc.edu/archives/hp3000-l.html *