Re: [sqr-users] Basic doubts about SQR

[Don Mellen <donm@ontko.com>]

Just to add a few thoughts....

On Wed, 22 Jan 2003, D Patel wrote:

> 1. Do we have any facilty in SQR so I can execute an
> existing SQL procedure which returns back me Reference
> Cursor? How can I retrieve data from the return value?

When you say "existing SQL procedure" do you mean "stored procedures" by
any chance?
 
> 3. I have dynamic SQL queries inside the SQR. Is there
> any way we can get query, which is being generated and
> executed (To check the result in SQL*Plus)?

As Richard Knapp pointed out, the best way to see the entire SQL as it
will be run (in SQR versions 6.2 and before) is to blow it up.  Easiest
way is to put a fake alias.column as the very last thing before the
end-select (I usually use "ka.boom" or something similar).  You can use
the compiler directive "#debug" to be able to run, then blow up, then run,
etc. during testing.

In SQR version 8.0, there is a reserved variable called $sql-text which
has the last executed BEGIN-SQL, BEGIN-SELECT, or LOAD-LOOKUP.


-----------------------------------------------------------------------
Donald Mellen  | Ray Ontko & Co. - Richmond, IN - http://www.ontko.com/
donm@ontko.com |  "In the beginning, there was nothing, which exploded"

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