RE: [sqr-users] Standard Error

["Peter Burton" <peter.burton@oracle.com>]

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

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