Re: Oracle hints

[Arnon Oppenheimer <arnono@SEMECH.CO.IL>]

Mark,

Use:
BEGIN-SELECT DISTINCT
/* +ORDERED */    ! at column 1 - without blanks before the /*  - like table
column in sqr

BTW, you can find this at /sqr/ora/readme/faq.txt  from Brio !

Regards,
Arnon Oppenheimer
 -------------------------------------------------------------------
 SEMECH SOFTWARE MARKETING LTD.
 TEL : (972) - 3 - 5333144
 FAX : (972) - 3 - 5333132
 Email: arnono@semech.co.il
 -------------------------------------------------------------------
----- Original Message -----
From: Pietersz Mark x8938 <mpieters@CITIPOWER.COM.AU>
To: <SQR-USERS@list.iex.net>
Sent: Friday, March 31, 2000 6:47 AM
Subject: Oracle hints


> Guys,
>
> I'm going nuts.  I'm trying to put an oracle ordered hint in a
BEGIN-SELECT
> DISTINCT statement.  I have tried to look on the sqr users archive list
but
> the information was not consistent
>
> the two methods suggested by the list are
>
> BEGIN-SELECT --+ORDERED
>
> BEGIN-SELECT /* +ORDERED */
>
> I have also tried
>
> BEGIN-SELECT
>   /* +ORDERED */
>
> None works for me.  They all typically produce "Bad param found on
> begin-select line".
>
> Also if I wish to use "distinct" with this where does the distinct go ?
> "BEGIN-SELECT DISTINCT {HINT}" OR "BEGIN-SELECT {HINT} DISTINCT"
>
> I am using SQRW 4.3.4 on NT 4.0 SP3 accessing Oracle 7.3.4.3.0.
Application
> is PeopleSoft
>
> Hope you can help
>
> TIA
>
> Mark Pietersz
>
>
>
> **********************************************************************
> This email and any files transmitted with it are confidential and
> intended solely for the use of the individual or entity to whom they
> are addressed. If you have received this email in error please notify
> the system manager.
>
> This email message has been swept for the presence of computer viruses.
>
> CitiPower Pty ACN 064 651 056
> **********************************************************************