RE: [sqr-users] SQR return-status

["Orr, Daniel E (Dan) TL26D" <Daniel.Orr@CIGNA.COM>]

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