Re: Oracle Hints

[Manoj Gurjar <mgurjar@HOTMAIL.COM>]

actually there is one debug option in SQR.
-s switch

u will get all the SQLs being sent to database.

hth,
manoj

>From: richard.mitchell@GSA.GOV
>Reply-To: sqr-users@list.iex.net
>To: SQR-USERS@list.iex.net
>Subject: Re: Oracle Hints
>Date: Mon, 3 Apr 2000 08:14:30 -0700
>
>Mark,
>
>This may have been mentioned previously but I don't have the thread.
>
>When I use substitution variables, I often get lost in the detail of what
>is getting sent in the Select. What I do is add a capital X to the end of
>the Select to see how SQR is putting it together. Usually I get ......where
>LOCATION = :1 X    when I actually want .....where LOCATION = 'MY LOCATION'
>X  which means I left the [  ] off the substitution variable again. I put
>the [ ] in again and run the program with the X on the end until I see the
>Select I want, then remove it to run the code.
>
>Sure would be nice if SQR would give a 'debug' option to view the Select.
>Hint, hint...
>
>Hope this helps,
>
>Rick
>
>
>--------------------------------- Reply -------------------------------
>
>Folks,
>
>Thanks for all your responses.  Seems that the problem that I am
>experiencing is related to SQR having problems with using substitution
>variables in the FROM part of a BEGIN-SELECT statement.  They just
>vapourize !!!   This in turn has caused the statement to be incorrectly
>formatted
>
>Regards
>
>Mark Pietersz

______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com