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

[Yuri Lakef <lakef250@yahoo.com>]

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