Changing DB2 Short or Internal Names

20 pts.
Tags:
Database
DB2/400
We never drop and recreate tables in production. We do regularly in test. Recently we used the ALTER statement to remove a column in a table. The internal or short name was obviously MAX_P00001 because now we only have a MAX_P00002 and a MAX_P00003(using DSPFFD). In test, the table has MAX_P00001 and MAX_P00002 but no 3. In test, we have a common library for the I/O modules. These modules are used by all test DB2 libraries. If we restore the production version of above mentioned table into a test library, we get a -901 on the select. If we recompile the I/O program into the library with the restored table, then it works. Is there any way of forcing the production table to use MAX_P00001 and MAX_P00002 without dropping and recreating the table?
ASKED: April 29, 2008  8:33 PM
UPDATED: October 30, 2009  11:30 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • TomLiotta
    Is a "recompile" all that you need to do to get it to work? You make no changes at all to any source code? Is this an SQL program? What OS version/release? What language is the programming written in? Tom
    125,585 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following