A helpful error message

IBM
DB2
just gave me this far from helpful error
message:

DB21034E  The command was processed as an SQL statement because it was not a
valid Command Line Processor command.  During SQL processing it returned:
SQL0010N  The string constant beginning with "'" does not have an ending
string delimiter.  SQLSTATE=42603

As a human, or a close facsimile of one, I don’t need to
know the internal server codes DB21034E and
SQL0010N. I don’t need to know that the command was
processed as an SQL statement, because that’s what I was
hoping it would be all along. And I definitely don’t want
to know that SQLSTATE is 42603, for I’m not sure if it
would be very much better or worse if it were 42604. Or 2.
Or, for that matter, 999999999996.

And all this for mismatched quotes around a string.

Leave a Reply

Your email address will not be published. Required fields are marked *