SQLState=01534 [SQL0181] when running DML instruction in System i Navigator

Tags:
RDI
SQL
System i
Hello,
I'd like to avoid the message SQLState=01534 [SQL0181].
This appears whenever I run a DML instruction in System i navigator or RDI or ...
Thanks for helping!
Mathy Paesen


Software/Hardware used:
RDI
0

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • TheRealRaven
    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.
    36,430 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: