RE: [sqr-users] SQR return-status

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

Excellent..
It worked.
Thank you so much Datta.

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 Dattatraya Shetty
Sent: Tuesday, August 31, 2004 1:30 PM
To: This list is for discussion about the SQR database reporting
languagefrom Hyperion Solutions.
Subject: RE: [sqr-users] SQR return-status


Murali,
    I think you are running on Windows, if I am not wrong? 

In that case try something like this in your  batch file 


SQR pgm.sqr X/X -flags 
IF ERRORLEVEL 101 GOTO FAILED
EXIT 0 
:FAILED 
EXIT 101 

HTH 
Datta. 

--- "Orr, Daniel E (Dan)      TL26D" <Daniel.Orr@CIGNA.COM> wrote:

> If you are running from within a Shell script you need to have the
> script
> return the error code -
> 
> Immediately after the 'SQR' statement include the following
> retcode=$?
> exit $retcode
> 
> Daniel Orr
> 
> 
> -----Original Message-----
> From: Kaithi, Murali [mailto:Murali.Kaithi@spencergifts.com] 
> Sent: Tuesday, August 31, 2004 1:00 PM
> To: This list is for discussion about the SQR database
> reportinglanguage
> from Hyperion Solutions.
> Subject: RE: [sqr-users] SQR return-status
> 
> 
> 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 
>
______________________________________________________________________
> 
> _______________________________________________
> sqr-users mailing list
> sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users
> 
> "MMS <internal.cigna.com>" made the following annotations.
>
------------------------------------------------------------------------------
> CONFIDENTIALITY NOTICE: If you have received this e-mail in error,
> please
> immediately notify the sender by e-mail at the address shown.  This
> e-mail
> transmission may contain confidential information.  This information
> is
> intended only for the use of the individual(s) or entity to whom it
> is
> intended even if addressed incorrectly.  Please delete it from your
> files if
> you are not the intended recipient.  Thank you for your compliance.
> Copyright
> (c) 2004 CIGNA
>
==============================================================================
> 
> 
> _______________________________________________
> sqr-users mailing list
> sqr-users@sqrug.org
> http://www.sqrug.org/mailman/listinfo/sqr-users
> 



                
__________________________________
Do you Yahoo!?
Yahoo! Mail - Helps protect you from nasty viruses.
http://promotions.yahoo.com/new_mail

_______________________________________________
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 
______________________________________________________________________

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