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