-186   THE LOCAL DATE LENGTH OR LOCAL TIME LENGTH HAS BEEN INCREASED AND EXECUTING PROGRAM RELIES ON THE OLD LENGTH

Explanation

The local format option has been used with a datetime value and DB2® has discovered that the datetime exit routine has been changed to produce a longer local format.

System action

The statement cannot be processed.

Programmer response

If the statement receiving this error is embedded in the application program, then a REBIND command must be issued for the application plan. If the statement was dynamic SQL, then the statement can be reentered.

SQLSTATE

22505