logo  
Google
 

DB2 SQL-Error: -186

SQLState: 22505

Short Description: THE LOCAL DATE LENGTH OR LOCAL TIME LENGTH HAS BEEN INCREASED AND EXECUTING PROGRAM RELIES ON THE OLD LENGTH

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 executed. 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.

 <-  BACK TO INDEX