The Bind syntax for the PLAN that results in the SQLCODE -812 is:
BIND PLAN(DOETPC1) PKLIST(*.DONOCOL) -
DEGREE(1) VALIDATE(BIND) ISOLATION(CS) -
FLAG(E) CURRENTDATA(NO) RELEASE(COMMIT) -
RETAIN CACHESIZE(0) ACQUIRE(USE) -
EXPLAIN(NO) ACTION(REPLACE)
The Bind syntax for the PLAN that results in clean run is:
BIND PLAN(DOETPC1) PKLIST(*.DONOCOL.*) -
DEGREE(1) VALIDATE(BIND) ISOLATION(CS) -
FLAG(E) CURRENTDATA(NO) RELEASE(COMMIT) -
RETAIN CACHESIZE(0) ACQUIRE(USE) -
EXPLAIN(NO) ACTION(REPLACE)