Re: ORACLE Performance Hints in SQR

[David Dawes Stanley <stanledd@SNYONEVA.CC.ONEONTA.EDU>]

It looks like to me you are using C comments instead of SQR comments.
Try this:
ie: begin-SELECT ! +FIRST_ROWS

        I have a nice little program I wrote many years ago that displays a Test
Pattern on my computer screen(Just like TV). It is available at my web site
and you are welcome to it. I find it helpful to sit on my SQR manuals and
stare at the test pattern. Most the time the answer comes to me.

        Hope this helps
David Dawes Stanley
Lead Programmer Analysis/Web Master
SUNY SICAS Center
http://www.oneonta.edu/~stanley

>-----Original Message-----
>From: Discussion of SQR, SQRIBE Technologies's database reporting
>language [mailto:SQR-USERS@list.iex.net]On Behalf Of Jerry C
>Sent: Friday, November 13, 1998 8:41 AM
>To: Multiple recipients of list SQR-USERS
>Subject: ORACLE Performance Hints in SQR
>
>
>Has anyone succeeded in doing this?  Example:
>
>begin-SELECT /*+FIRST_ROWS*/
>etc.
>
>This won't compile in SQR.  It would be nice to have the ability to include
>hints.
>
>Thanks.
>