Re: How to use HINT statement in SQR ?

[Arun Kumar <arunkumar13@YAHOO.COM>]

Rick
try this....


begin-select on-error=sql_error
/*+ALL_ROWS*/
distinct pa.business_unit      &pa.business_unit
pa.contract_num_pc    &pa.contract_num_pc

--- Rick_Creel@AONCONS.COM wrote:
> I am trying use a HINT in an SQR select.  The only
> way I could get it to be
> accepted syntax-wise was to code the statement like
> this:
>
> begin-select distinct on-error=sql_error
> /*+ALL_ROWS*/
> pa.business_unit      &pa.business_unit
> pa.contract_num_pc    &pa.contract_num_pc
> pa.contract_line_num  &pa.contract_line_num
> cl.eff_status         &cl.eff_status
> cl.effdt              &cl.effdt
>    do process_stuff
> from ps_proj_activity   pa,
>      ps_pc_contract_lin cl
> where pa.business_unit = $req_business_unit
> and   pa.project_id    = $req_project_id
> and   blah blah blah
> end-select
>
> When SQR parses out this command, it becomes:
>
> select distinct /*+ALL_ROWS*/ pa.business_unit,
> pa.contract_num_pc,
> pa.contract_line_num   .... blah blah blah
>
> However, in order for it to work properly, it needs
> to be parsed as:
>
> select  /*+ALL_ROWS*/ distinct pa.business_unit,
> pa.contract_num_pc,
> pa.contract_line_num   .... blah blah blah
>
> Anyone know how to make this happen?  I have tried
> many different versions of
> the BEGIN-SELECT statement,
> but the only one I could get to work was the one
> shown above.
>
> Any help would be greatly appreciated!


__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/