Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2010
    Posts
    1

    Unanswered: Need urgent help in table load

    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.

  2. #2
    Join Date
    Dec 2005
    Posts
    273
    The UNLOAD utility generates a load control statement ( SYSPUNCH DD ... ). Do you use that card or another ? If it's an other compare those cards for any difference.

    Are the table definitions identical ( maybe 'INVSTGN_OWNER_NM' is nullable in Prod but is not in PreProd )

    Do you use any definitions on the ProdServer which were introduced in Version 9 ( BIGINT e.g. )

    Have a look at the discarded record. What is the content of the field 'INVSTGN_OWNER_NM' ?
    Last edited by umayer; 06-23-10 at 09:36.

  3. #3
    Join Date
    Jul 2009
    Location
    NY
    Posts
    963
    GMDMVP1.HELP_TEXT could not be packed-decimal. It's following from name of the column.

    Maybe you use the old "load control statement"

    Lenny

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •