SQL State 01534 is "The string representation of a datetime value
is invalid." And message SQL0181 is "Value in date, time, or timestamp string not valid." The SQL State values are in the SQL documentation, and message ID SQL0181 can simply be displayed on the server.
So, make sure you specify date, time and timestamp values using the proper formats.
You need to show us an actual example statement that fails. If the statement contains no date, time or timestamp values, then most likely your server needs a current DB2 group PTF package or your System i Access needs a current fix pack.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!
Discuss This Question: 1 Reply
So, make sure you specify date, time and timestamp values using the proper formats.
You need to show us an actual example statement that fails. If the statement contains no date, time or timestamp values, then most likely your server needs a current DB2 group PTF package or your System i Access needs a current fix pack.