Oracle hints

[Pietersz Mark x8938 <mpieters@CITIPOWER.COM.AU>]

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
**********************************************************************