Re: How do I use a HINT in SQR ?

["Thomas D. Hins" <Thomas-Hins@OUHSC.EDU>]

try this, exclamation points indicate hints or comments
begin-select on-error=sql_error !INDEX(PPCL PS#PC_CONTRACT_LIN)
USE_HASH(MAP)
 Tom Hins
Information Technology - Application Solutions
University of Oklahoma Health Sciences Center
P.O. Box 26901
Oklahoma City, OK  73190
Phone:(405) 271-2262 Ext. 50213
Fax: (405) 271-2352


-----Original Message-----
From: Rick_Creel@AONCONS.COM [mailto:Rick_Creel@AONCONS.COM]
Sent: Thursday, June 28, 2001 8:56 AM
To: SQR-USERS@list.iex.net
Subject: How do I use a HINT in SQR ?


My environment:
Psoft 7.53
Oracle *.06
SQR  4.34

I need to add a HINT to a select statement in SQR.  I keep getting a syntax
error.  What is the proper format?
Here are the two ways I tried it, and both give a syntax error.  Any help
would
be most appreciated!

First Try:

begin-select on-error=sql_error /*+ INDEX(PPCL PS#PC_CONTRACT_LIN)
USE_HASH(MAP)
 */
res.business_unit
res.accounting_dt
blah
blah
from ps_proj_resource   res,
     ps_proj_activity   ppa,
     ps_pc_contract_lin ppcl,
     ps_proj_an_grp_map map
where ......

----------------------------------------------------------------------------
------------------

Second Try:

begin-select /*+ INDEX(PPCL PS#PC_CONTRACT_LIN) USE_HASH(MAP) */
on-error=sql_error
res.business_unit
res.accounting_dt
blah
blah
from ps_proj_resource   res,
     ps_proj_activity   ppa,
     ps_pc_contract_lin ppcl,
     ps_proj_an_grp_map map
where ......