{"id":94,"date":"2003-12-31T13:10:13","date_gmt":"2003-12-31T17:10:13","guid":{"rendered":"http:\/\/scruss.com\/blog\/?p=94"},"modified":"2003-12-31T13:10:13","modified_gmt":"2003-12-31T17:10:13","slug":"a-helpful-error-message","status":"publish","type":"post","link":"https:\/\/scruss.com\/blog\/2003\/12\/31\/a-helpful-error-message\/","title":{"rendered":"A helpful error message"},"content":{"rendered":"<p><a href=\"http:\/\/www-306.ibm.com\/software\/data\/db2\/\">IBM<br \/>\nDB2<\/a> just gave me this far from helpful error<br \/>\nmessage:<\/p>\n<pre>\nDB21034E  The command was processed as an SQL statement because it was not a\nvalid Command Line Processor command.  During SQL processing it returned:\nSQL0010N  The string constant beginning with \"'\" does not have an ending\nstring delimiter.  SQLSTATE=42603\n<\/pre>\n<p>As a human, or a close facsimile of one, I don&#8217;t need to<br \/>\nknow the internal server codes <q>DB21034E<\/q> and<br \/>\n<q>SQL0010N<\/q>. I don&#8217;t need to know that the command was<br \/>\nprocessed as an SQL statement, because that&#8217;s what I was<br \/>\nhoping it would be all along. And I definitely don&#8217;t want<br \/>\nto know that SQLSTATE is 42603, for I&#8217;m not sure if it<br \/>\nwould be very much better or worse if it were 42604. Or 2.<br \/>\nOr, for that matter, 999999999996.<\/p>\n<p>And all this for mismatched quotes around a string.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>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 &#8220;&#8216;&#8221; does not have an ending string delimiter. SQLSTATE=42603 As a human, or a [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[1],"tags":[1682,754,887],"class_list":["post-94","post","type-post","status-publish","format-standard","hentry","category-general","tag-db2","tag-error","tag-ibm"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/pQNZZ-1w","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/scruss.com\/blog\/wp-json\/wp\/v2\/posts\/94","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/scruss.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/scruss.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/scruss.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/scruss.com\/blog\/wp-json\/wp\/v2\/comments?post=94"}],"version-history":[{"count":0,"href":"https:\/\/scruss.com\/blog\/wp-json\/wp\/v2\/posts\/94\/revisions"}],"wp:attachment":[{"href":"https:\/\/scruss.com\/blog\/wp-json\/wp\/v2\/media?parent=94"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/scruss.com\/blog\/wp-json\/wp\/v2\/categories?post=94"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/scruss.com\/blog\/wp-json\/wp\/v2\/tags?post=94"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}