Allow for "OPTIMIZE FOR n ROWS" to be added to DELETE, UPDATE Statements

OPTIMIZE FOR 1 ROW can be added to SELECT SQL. One reason may be to influence the optimizer to chose one index over another, or to not perform a SORT with List Prefetch

Adding OPTIMIZE FOR 1 ROW to a DELETE statement results in an error:

EXPLAIN ALL SET QUERYNO = 1001 FOR

delete FROM dsn81210.emp

WHERE WORKDEPT = ?

optimize for 1 row

;

SQLERROR ON EXPLAIN COMMAND, PREPARE FUNCTION

RESULT OF SQL STATEMENT:

DSNT408I SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD OPTIMIZE.

EXPLAIN ALL SET QUERYNO = 1001 FOR

UPDATE

dsn81210.emp

SET WORKDEPT = ?

WHERE EMPNO = ?

optimize for 1 row

;

QLERROR ON EXPLAIN COMMAND, PREPARE FUNCTION

RESULT OF SQL STATEMENT:

DSNT408I SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD OPTIMIZE.