RE: [sqr-users] Standard Error

["Joe R. Jah" <jjah@cloud.ccsf.cc.ca.us>]

On Thu, 9 Aug 2007, Peter Burton wrote:

> Date: Thu, 9 Aug 2007 13:55:04 -0400
> From: Peter Burton <peter.burton@oracle.com>
> Reply-To: This list is for discussion about the SQR database reporting
    language from Hyperion Solutions. <sqr-users@sqrug.org>
> To: This list is for discussion about the SQR database reporting language
    from Hyperion Solutions. <sqr-users@sqrug.org>
> Subject: RE: [sqr-users] Standard Error
> 
> Joe,
> 
> All console output generated by SQR goes to Standard Output.  You can
> however separate error related messages from non-error related
> messages by using the -E and -O flags.
> 
> Peter

Thanks again Peter.  The line "sqr -E {pgm} {connectivity} [flags]"
creates a program.err in the program directory; I've written two
statements in the shell script right after running the sqr program to
concatenate it to the Standard Error and delete it:

 cat {pgm}.err 1>&2
 rm {pgm}.err >/dev/null

Thank you very much.


> -----Original Message-----
> From: sqr-users-bounces+peter.burton=oracle.com@sqrug.org 
>[mailto:sqr-users-bounces+peter.burton=oracle.com@sqrug.org] On Behalf Of Joe 
>R. Jah
> Sent: Thursday, August 09, 2007 1:39 PM
> To: This list is for discussion about the SQR database reporting language 
>from Hyperion Solutions.
> Subject: RE: [sqr-users] Standard Error
> 
> On Thu, 9 Aug 2007, Peter Burton wrote:
> 
> > Date: Thu, 9 Aug 2007 07:02:17 -0400
> > From: Peter Burton <peter.burton@oracle.com>
> > Reply-To: This list is for discussion about the SQR database reporting
>     language from Hyperion Solutions. <sqr-users@sqrug.org>
> > To: This list is for discussion about the SQR database reporting language
>     from Hyperion Solutions. <sqr-users@sqrug.org>
> > Subject: RE: [sqr-users] Standard Error
> >
> > Joe,
> >
> > If you are running under Unix/Linux invoke SQR under the Bourne Shell and 
>use something similar to this ...
> >
> >     sqr {pgm} {connectivity} [flags] 1>&2
> >
> > This will redirect all of the output that SQR writes to the Standard Output 
>to Standard Error
> >
> > Peter
> 
> Thank you Peter, but if I wanted to get all the output, I wouldn't
> redirect it to /dev/null in the first place.  I am not interested in
> getting an email on standard output each time the program runs.  I only
> want to receive email from cron daemon when error messages are involved;
> that's why, I redirect the output to /dev/null:
> 
>  sh program >/dev/null
> 
> The script 'program' includes several sqr programs and other shell
> programs.  I get an email from cron when error messages are produced by
> the shell programs in the script; however, it seems that sqr programs send
> their error messages, along with their normal output to Standard Output;
> hence, they go to /dev/null;( I wonder if there is any way around that.
> 
> > -----Original Message-----
> > From: sqr-users-bounces+peter.burton=oracle.com@sqrug.org 
>[mailto:sqr-users-bounces+peter.burton=oracle.com@sqrug.org] On Behalf Of Joe 
>R. Jah
> > Sent: Thursday, August 09, 2007 1:37 AM
> > To: sqr-users@sqrug.org
> > Subject: [sqr-users] Standard Error
> >
> > Hi All,
> >
> > I have shell a script that runs by cron with output redirected to
> > /dev/null. The script runs multiple sqr programs. I need to have
> > sqr error messages to go to Standard Error.  For example the following
> > message does not go to standard error:
> >
> > ---8<---
> > Error on line 153:
> >    (SQR 3204) Length of variables exceeds record length.
> >
> > SQR: Program Aborting.
> > ---8<---
> >
> > Please advise.
> >
> > Regards,
> >
> > Joe
> > --
> >      _/   _/_/_/       _/              ____________    __o
> >      _/   _/   _/      _/         ______________     _-\<,_
> >  _/  _/   _/_/_/   _/  _/                     ......(_)/ (_)
> >   _/_/ oe _/   _/.  _/_/ ah        jjah@cloud.ccsf.cc.ca.us
> >
> >
> > _______________________________________________
> > sqr-users mailing list
> > sqr-users@sqrug.org
> > http://www.sqrug.org/mailman/listinfo/sqr-users
> >
> >
> > _______________________________________________
> > sqr-users mailing list
> > sqr-users@sqrug.org
> > http://www.sqrug.org/mailman/listinfo/sqr-users
> >
> 
> Joe
> --
>      _/   _/_/_/       _/              ____________    __o
>      _/   _/   _/      _/         ______________     _-\<,_
>  _/  _/   _/_/_/   _/  _/                     ......(_)/ (_)
>   _/_/ oe _/   _/.  _/_/ ah        jjah@cloud.ccsf.cc.ca.us
> 
> 
> 
> _______________________________________________
> sqr-users mailing list
> sqr-users@sqrug.org
> http://www.sqrug.org/mailman/listinfo/sqr-users
> 
> 
> _______________________________________________
> sqr-users mailing list
> sqr-users@sqrug.org
> http://www.sqrug.org/mailman/listinfo/sqr-users
> 

Joe
-- 
     _/   _/_/_/       _/              ____________    __o
     _/   _/   _/      _/         ______________     _-\<,_
 _/  _/   _/_/_/   _/  _/                     ......(_)/ (_)
  _/_/ oe _/   _/.  _/_/ ah        jjah@cloud.ccsf.cc.ca.us


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