PH36514: DATATYPE CHANGE DECIMAL TO VARCHAR LOAD FAILS INVALID HEXADECIMAL OPERAND - X' '

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When applying a change of a column datatype from
  DECIMAL to VARCHAR, the load may fail with an
  error such as the following:
  
  LOAD DATA INDDN XXXXXXXX LOG NO  RESUME YES
   EBCDIC  CCSID(00037,00000,00000)
   INTO TABLE >tablename<
   WHEN(00001:00002) = X'0003'
   NUMRECS                    2
     (
      COL1                                  POSITION(    3:   38)
        CHAR(   36) STRIP TRAILING X' '              ,
  INVALID HEXADECIMAL OPERAND - X' '
      COL2                                  POSITION(   39:   40>
        DECIMAL                                      ,
      COL3                                  POSITION(   41:  297)
        VARCHAR
     )
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the Db2 Administration Tool for     *
  *                 z/OS and Db2 Object Comparison Tool for z/OS *
  ****************************************************************
  * PROBLEM DESCRIPTION: An invalid LOAD statement may be        *
  *                      generated when converting a table       *
  *                      column type from DECIMAL to VARCHAR.    *
  ****************************************************************
  When converting a table column type from DECIMAL to VARCHAR,
  the converted control card might have an invalid LOAD
  statement, such as the one so indicated in the following
  example:
  
  LOAD DATA INDDN H2J6EYC1 LOG NO  RESUME YES
   EBCDIC  CCSID(00037,00000,00000)
   INTO TABLE "SCHEMA"."TABLA01"
   WHEN(00001:00002) = X'0003'
   NUMRECS                    2
     (
      COL1                            POSITION(    3:   38)
        CHAR(   36) STRIP TRAILING X' '              ,
  INVALID HEXADECIMAL OPERAND - X' '
      COL2                                POSITION(   39:   40)
        DECIMAL                                      ,
      COL3                                  POSITION(   41:  297)
        VARCHAR
     )
  

Problem conclusion

• The problem has been resolved.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UI76346

Modules/Macros

• ADB27AC
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI76346

     UP21/07/21 P F107

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.