RE: FW: [sqr-users] SQR return-status

["Kaithi, Murali" <Murali.Kaithi@spencergifts.com>]

Hi Don,
Yes, the batch file is running just sqr.
As you said because the batch is getting completed so the status might be 
getting returned success.
I couldn't understand your last statement properly about "pass on" the return 
status from the SQR. Could you please elaborate this for me.
Please find below the code where I am using the variable #return-status in my 
sqr program.

begin-procedure Open-Files

  let $FullFileName = {PTDWDIR} || {PTDFILE}
  open $FullFileName as 10
        for-reading
        record=400:vary
        status= #filestat
        if #filestat != 0
        move 101 to #return-status
    #debugb      show 'Open for file 10 failed'
                 move #return-status to $return-status
                 show 'Return-Status is ' $return-status
    #debugb      stop quiet
        else
          do validateptd-file
        end-if        

Thanks,
Muralidhar R Kaithi
Sr. Tech Specialist, PeopleSoft
(609) 645-5524
murali.kaithi@spencergifts.com


-----Original Message-----
From: Don Mellen [mailto:donm@ontko.com]
Sent: Tuesday, August 31, 2004 1:10 PM
To: Kaithi, Murali
Subject: Re: FW: [sqr-users] SQR return-status


Is your batch file handling the receipt of that error?  You said "The
scheduler just runs the Batch file in..."  Does that batch file run the
SQR?  If so, the batch file *is* completing succesfully, so you need to
"pass on" the return status from the SQR.

HTH,
Don

On Tue, 31 Aug 2004, Kaithi, Murali wrote:

> Thanks Don for replying.
> I have tried your resolution before I posted this problem.
> My program is stopped quitely but the scheduler is still showing completed 
>with OK status.
> Any Ideas please.
> 
> Thanks,
> Muralidhar R Kaithi
> Sr. Tech Specialist, PeopleSoft
> (609) 645-5524
> murali.kaithi@spencergifts.com
> 
> 
> -----Original Message-----
> From: sqr-users-bounces+murali.kaithi=spencergifts.com@sqrug.org
> [mailto:sqr-users-bounces+murali.kaithi=spencergifts.com@sqrug.org]On
> Behalf Of Don Mellen
> Sent: Tuesday, August 31, 2004 12:08 PM
> To: This list is for discussion about the SQR database reporting
> languagefrom Hyperion Solutions.
> Subject: Re: [sqr-users] SQR return-status
> 
> 
> Before issuing the STOP QUIET, set the reserved variable "#return-status"
> to the value you want for the error, I ussually start my "internal" errors
> at 101 and go up from there (if you want specific error codes and to
> have them separate from OS error codes).  Just to set an error you can...
> 
>    move 101 to #return-status
> 
> HTH,
> Don
> 
> On Tue, 31 Aug 2004, Kaithi, Murali wrote:
> 
> > Let me explain my situation here.
> > we scheduled lot of SQR jobs thru Arcana scheduler. The scheduler just 
> > runs the Batch  file in which all the SQR flags are set.
> > I have used -XCB flag for the purpose that I shouldn't get any windows
> > on the server where these jobs are run.  I want to get an email when
> > any job fails and there is a parameter in the scheduler saying that if
> > the job fails it will automatically sends an email.  My problem is
> > even if the job fails for any reason the scheduler is showing as the
> > job is completed OK because of the fact that the SQR is not passing
> > the right #return-status to the operating system (in this case the
> > Arcana Scheduler).
> > In my SQR program I am saying STOP QUIET if I want the job to stop
> > instead of using just STOP because of the fact that I don't want any
> > window popping up on the server saying "Program stopped by user
> > request."  To put it simple, I want the program to pass the error
> > return-status to the scheduler whenever I am stopping the SQR for any
> > reason.  Could anybody please help me on this.
> > 
> > 
> > Thanks,
> > Murali
> > 
> > ______________________________________________________________________
> > This email has been scanned by the MessageLabs Email Security System.
> > For more information please visit http://www.messagelabs.com/email 
> > ______________________________________________________________________
> > 
> > _______________________________________________
> > sqr-users mailing list
> > sqr-users@sqrug.org
> > http://www.sqrug.org/mailman/listinfo/sqr-users
> > 
> 
> -----------------------------------------------------------------------
> Donald Mellen  | Ray Ontko & Co. - Richmond, IN - http://www.ontko.com/
> donm@ontko.com |  "In the beginning, there was nothing, which exploded"
> 
> 
> _______________________________________________
> sqr-users mailing list
> sqr-users@sqrug.org
> http://www.sqrug.org/mailman/listinfo/sqr-users
> 
> ______________________________________________________________________
> This email has been scanned by the MessageLabs Email Security System.
> For more information please visit http://www.messagelabs.com/email 
> ______________________________________________________________________

-----------------------------------------------------------------------
Donald Mellen  | Ray Ontko & Co. - Richmond, IN - http://www.ontko.com/
donm@ontko.com |  "In the beginning, there was nothing, which exploded"


______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email 
______________________________________________________________________

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users