Re: Command line flag -S

[Paul Hoyte <phoyte@SHARIDIONNE.COM>]

The information that is provided by using the -S flag is not permanently
stored in any location. It is stored in memory for the duration of the
execution and posted to the log file.  After the job its gone!!!  HTH

Paul Hoyte
Sharidionne, Inc.
(248) 559-6868
www.sharidionne.com
phoyte@sharidionne.com

-----Original Message-----
From: Discussion of SQR, Brio Software's database reporting language
[mailto:SQR-USERS@list.iex.net]On Behalf Of Sarah Debbink
Sent: Thursday, February 21, 2002 8:56 AM
To: SQR-USERS@list.iex.net
Subject: Re: Command line flag -S


Hi,

Actually I tried searching the V$ tables and can find anything like this.

Thanks,
Sarah




                    Ray Ontko
                    <rayo@ONTKO.CO        To:     SQR-USERS@list.iex.net
                    M>                    cc:     (bcc: Sarah
Debbink/AGConsult)
                    Sent by:              Subject:     Re: Command line
flag -S
                    "Discussion of
                    SQR, Brio
                    Software's
                    database
                    reporting
                    language"
                    <SQR-USERS@lis
                    t.iex.net>


                    02/19/2002
                    10:23 PM
                    Please respond
                    to sqr-users






Sarah,

> For a multitude of reasons that I won't go into right now, I'm trying to
> find out where the information generated using the -S command line flag
is
> stored BEFORE it is written to the .log file.  My thinking is that it has
> to be stored somewhere in order for the Compiles, Executes and Rows
> information can be written to the .log file.
>
> Is this information put in an array or system table that I'd be able to
get
> to via SQR?  I'm running on Oracle8i.

I'm certain that if this information is available at runtime,
the means for getting at it is not documented in the SQR
manuals.

If I had to guess, it's being stored internal to the SQR
executor and is not being fetched from Oracle after the
program runs.  The "-s" feature has been part of SQR for
a long time and is supported on all database platforms
as far as I know.

You _may_ be able to get similar information from the
V$ tables in Oracle.

Or, there may be an undocumented mechanism for getting
it from SQR.

Hope this helps.

Ray
----------------------------------------------------------------------
Ray Ontko   rayo@ontko.com   Phone 1.765.935.4283   Fax 1.765.962.9788
Ray Ontko & Co.   Software Consulting Services   http://www.ontko.com/