PM98002: VARCHAR DATA CONSTANT CONVERTED INTO A CHAR DATA TYPE COLUMN LENGTH IS LESS THAN THE LENGTH ATTRIBUTE OF SOURCE DATA

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• A logical unload requesting a varchar data type constant to be
  converted into a char data type column which length is less than
  the length attribute of the source data (varchar constant)
  produces a wrong output field. The expected padded zone of the
  field is filled out with unpredictable bytes.
  
  For example, this occurs with a logical unload with the
  following SELECT statement :
  
  SELECT VARCHAR('CONST', 10) INTO C1 CHAR FROM ....
  
  In such a case, the output field could be something like
  ""CONSTa.r@}""."
  
  PB11996
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: A logical unload requesting a varchar   *
  *                      data type constant be converted into a  *
  *                      char data type column which length is   *
  *                      less than the length attribute of the   *
  *                      source data (varchar constant)          *
  *                      produces a wrong output field. The      *
  *                      expected padded zone of the field is    *
  *                      filled out with unpredictable bytes.    *
  *                      For example, this occurs with a         *
  *                      logicla unload with the following       *
  *                      SELECT statement :                      *
  *                      SELECT VARCHAR('CONST', 10) INTO C1     *
  *                      CHAR FROM .... In such a case, the      *
  *                      output field could be something like    *
  *                      "CONSTa.r@}".                           *
  *                      PB 11996                                *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  The inznode, inznode modules were fixed.
  

Problem conclusion

• APPLY the PTF.
  

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:

Modules/Macros

• INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R410 PSY UK98654

     UP13/10/27 P F310

• R420 PSY UK98655

     UP13/10/27 P F310

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.