Using ODBC, I only seem to be able to get the long name returned. Is there any way to change or affect which column names are returned via ODBC?
Versions of my database has been deployed on Oracle (which does not support the column alias feature) and iSeries, and the tool I am using to copy data between them is hitting problems with column-matching. Ideally I would not have to recode the application, or amend the DB2 database to get around this.
Unfortunately it sounds like you're having to deal with the complexities that arise when you move a copy of your DB2 data to another database.
Dig Deeper on DB2 UDB (universal databases)
Related Q&A from Kent Milligan
Create a host variable of the where in statement on the fly with dynamic SQL. Continue Reading
To solve the SQL error -321 on IBM i6.1, use the new values statement to overcome the error. If you are using an older release, declare a cursor ... Continue Reading
When developing tables in a parent-child relationship, use a primary key and a foreign key along with a unique ID to make your database easier to ... Continue Reading