[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

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