IBMi V6R1 to V7R1 TR10 Gotcha – ODBC – No Field Names retrieved

The odbc connection is connecting to the IBMi (formerly known as iSeries, As400) and pulling back “physical files”/”table names”, but not pulling back column names.  The errors from UPS World Ship were “The selected import/export map is no longer valid because the column names in the external database have changed.”  “Import data source not valid.”

Ways to try and resolve this issue

  1. Install the latest IBM i Access v7.1 windows client to get the latest ODBC driver.
  2. Install the latest service pack for IBM i Access (SI55797_64a.exe at the time of this writing)
  3. Delete QGPL/QZDAPKG
  4. RCLDBXREF OPTION(*CHECK) if there is a problem try RCLDBXREF OPTION(*FIX). If that doesn’t work try RCLSTG SELECT(*DBXREF) when the system can be put into a restricted state and the system can be down for a bit.

References

Deleting QGPL/QADAPKG  http://www-01.ibm.com/support/docview.wss?uid=nas8N1015556

RCLDBXREF –  http://www-01.ibm.com/support/knowledgecenter/ssw_ibm_i_61/cl/rcldbxref.htm

RCLSTG – http://www-01.ibm.com/support/docview.wss?uid=nas8N1010683

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s