Restrictions on Optimizer Directives

You can specify optimizer directives for any query in a DELETE, SELECT, or UPDATE statement, unless it includes any of the following syntax elements:

• A query that accesses a table outside the current database
• In ESQL/C, a statement with the WHERE CURRENT OF cursor clause