IBM DB2 for i error messages using short column names in errors

3
votes

Note this question is specific to "IBM DB2 for i", the IBM i operating system's version of DB2.

The below screenshot shows a purposely erroneous INSERT statement that produces an SQL error of SQL0407.

My question... Is there a DB2, JDBC, or other setting I can alter so the long column names are used in the error vs. the cryptic short ones? Note I used the long column names in the INSERT statement.

insert with error

2
ibm-midrangedb2-400
I'm afraid I don't have an answer for you Aaron but yay for getting Redmine running on the IBM i! – Benny Hill
Redmine is being ported to run in PowerRuby on IBM i (in case you didn't know about PowerRuby) – aaronbartell

2 Answers

3
votes

Carol Ramler, DB2 for i Senior Software Engineer at IBM, responded with this:

In this situation it is the low level database manager code that is generating the error and it does not fill in the long column name due to historical and performance reasons.

Given her title I trust she is right :-)

0
votes

After looking over the JDBC properties documentation on InfoCenter ... Have you tried the JDBC properties of "errors"="full" and/or "extended metadata" = "true"?