In this post, you’ll learn about the error message -185 the local format option has been used with a date or time and no local exit has been installed in the IBM DB2 database , the reason why it occurs along with the solution to fix it
IBM DB2 Error Message
-185 the local format option has been used with a date or time and no local exit has been installed
Reason for the Error
The local format option has been used with a datetime value and no datetime exit has been installed.� This may occur if the LOCAL DATE LENGTH or LOCAL TIME LENGTH on the Installation Application Programming Defaults Panel indicated that an exit for datetime was supplied, but in fact the exit supplied by DB2 was not replaced.� This may also occur if the datetime exit was replaced and the corresponding LOCAL DATE LENGTH or LOCAL TIME LENGTH on the Installation Application Programming Defaults Panel was not set to a non-zero value.
Solution
Contact the system programmer about installation of the date or time exit.
