Index Hint No Longer Supported In 11+?

pinne65

Member
On OE 11.6, RHEL 5.11 in the procedure editor:

Don't remember if/when I used index hins before. But I can't get it to work.

SELECT Order.orderNum,
Order.entDate,
Order.entCode,
Order.whsLoc,
Order.totMerch
FROM Order WITH (INDEX(updatedAtIdx))
WHERE DATETIME('2017-09-12 00:00:00') <= updatedAt
AND tranType = 'order'

=>

** Unable to understand after -- "FROM Order WITH". (247)
** Line 6. Invalid SQL statement. (945)

Manual says this though:

SELECT column_list
FROM table_name [ [ AS ] table_alias ]
[ WITH (INDEX ( index_val ))] ...
WHERE ...

Any hints?
 

Rob Fitzpatrick

ProgressTalk.com Sponsor
It seems to me that index hints are for the SQL92 query engine only. When you enter SQL statements in the procedure editor you are using the deprecated SQL89 interface in the 4GL engine.

Try using sqlexp or some other SQL client instead.
 
Top