Re: Oracle Hints

["Salem, Mark" <msalem@MSA.COM>]

Place your Oracle hint on the same line as the Begin-Select -- NOT on its
own line and especially not in column 1.

> -----Original Message-----
> From: Larry Young
> Sent: Tuesday, September 07, 1999 11:54 AM
> To:   Multiple recipients of list SQR-USERS
> Subject:      Oracle Hints
>
> Hi, I am trying to run a SQR with the following in the select statement
>
> begin-select
>  /*+ ordered */
> B.BUSINESS_UNIT (0,0)        on-break   print=never  level=1
> after=bu-total
> L.DESCR         (0,0)        on-break   print=never  level=1
> CO.DST_ID_AR    (0,0)        on-break   print=never  level=2
> after=External-Total
> B.CUST_ID       (0,0)        on-break   print=never  level=3
> after=customer-total
> U.NAME1
> B.ITEM
> B.ITEM_LINE
> B.BAL_AMT_BASE
>
> etc...etc. etc......
>
> Can someone tell me if /*+ ordered */ is still supported under SQR 4
> because I am getting
> the following error message.
>
>
> Error on line 242:
>    (SQR 3721) Bad param found on 'BEGIN-SELECT' line; Format is:
>  BEGIN-SELECT [DISTINCT] [-Cnn] [-Bnn] [LOOPS=nn]
>               [ON-ERROR=procedure[(arg1[,argi]...)]]
>  /*+ ordered */
>
>
> The select works in SQR 3.
>
> Any suggestions would be appreciated.
>
> Thanks
>
> Larry