Tag: db2

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