We unloaded data from the Prod server tables and are trying to load to the Pre Prod server in an application running on MVS on Mainframes. We are using Unload and load utilities . However we are getting the following error for DECIMAL and VARCHAR columns while loading data onto the Pre Prod server tables.
1. CONVERSION ERROR FOR GMDMVP1.HELP_TEXT
ERROR CODE '04 - INPUT PACKED DECIMAL IS IN ERROR'
2. RECORD (3) WILL BE DISCARDED DUE TO INVALID 'INVSTGN_OWNER_NM' COLUMN
SPECIFICATION FOR GMDMVP1.WEB_SECURITY
What we have seen is that Prod is having DB2 V8 whereas Pre Prod is having DB2 V9 .Could this version difference be a reason for this issue? Please advise.We are doing a data refresh urgently needed for the client for fron end server migration and appreciate your help on this.