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
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
IBM did not change the default of the reuse deleted files function to YES for physical files in order to minimize the impact on any existing ... Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.