Re: [sqr-users] -S flag for cursors

[Ray Ontko <rayo@ontko.com>]

Yuri, (Peter),

I can't answer with authority (since I don't have access to the 
source code), but it was my understanding that PSSQR 8.0 = SQR 6.2.
That's when the fork occurred, I think.

Of course, you can simply try looking at $sql-text after a 
begin-select or begin-sql block and see if it contains anything.

Peter: Thanks for this exciting feature addition to sqr 8.0!

Ray

On Tue, Jan 20, 2004 at 02:56:50PM -0800, Yuri Lakef wrote:
> Thank you, Peter.  We are using PeopleSoft 8.4 version (not sure what that 
>translates to for the non-PeopleSoft world of SQR ever since PS licensed their 
>own version of SQR for 8.0).  Anyone else?  Thank you in advance.
> 
> 
> Peter Burton <Peter_Burton@Hyperion.com> wrote:Yuri,
> 
> If you have SQR 8.0 (or higher) from Brio (or Hyperion) you can examine the
> SQR resevered variable $SQL-TEXT after a BEGIN-SELECT or BEGIN-SQL block to
> see exactly what was sent to the database.
> 
> The -S command line flag only shows you the last SQL statement used for all
> the cursors when the report terminates. Note that cursors get reused in
> SQR. If the SQL is dynamic (i.e. bind and/or dynamic variables were used)
> then you will see the template.
> 
> Peter
> 
> > -----Original Message-----
> > From: sqr-users-admin@sqrug.org@HYPERION On Behalf Of Yuri Lakef
> > 
> > Sent: Tuesday, January 20, 2004 2:44 PM
> > To: sqr-users@sqrug.org
> > Subject: [sqr-users] -S flag for cursors
> > 
> > 
> > Is there a way to view the values of bind variables when using -S flag for
> > cursors?
> > 
> > 
> > ---------------------------------
> > Do you Yahoo!?
> > Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
> > 
> > _______________________________________________
> > sqr-users mailing list
> > sqr-users@sqrug.org
> > http://www.sqrug.org/mailman/listinfo/sqr-users
> > 
> Here was a non admissible message part of 'application/ms-tnef' MIME
> type. It has been automatically discarded before sending the message to
> the list. 
> 
> 
> 
> ---------------------------------
> Do you Yahoo!?
> Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
> 
> _______________________________________________
> sqr-users mailing list
> sqr-users@sqrug.org
> http://www.sqrug.org/mailman/listinfo/sqr-users
----------------------------------------------------------------------
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/

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