In this post, you’ll learn about the error message -186 the local date length or local time length has been increased and executing program relies on the old length in the IBM DB2 database , the reason why it occurs along with the solution to fix it
IBM DB2 Error Message
-186 the local date length or local time length has been increased and executing program relies on the old length
Reason for the Error
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.
Solution
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 may be re-entered.
