PM29261: SAVE DATA GENERATES ERROR MSG DXYE0172

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Issuing SAVE DATA generates error msg:
  One or more columns in SAVE_DATA and DATA are defined
  differently and entering PF1 generates Message DXYE0172
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All QMF for TSO/CICS V10 users.              *
  ****************************************************************
  * PROBLEM DESCRIPTION: QMF prevented saving data to a table    *
  *                      or importing data to a table if the     *
  *                      data types in the source and object     *
  *                      columns were defined with different     *
  *                      null characteristics.  Error message    *
  *                      DSQ20892 (MSGDSQ20892) was issued.      *
  *                                                              *
  *                      Error message DSQ23107 (MSGDSQ23107)    *
  *                      could also have been received during    *
  *                      IMPORT or SAVE DATA processing of       *
  *                      tables containing XML columns.          *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When DB2 added support allowing more implicit casting of one
  data type to another (such as saving an integer value into a
  column defined as decimal), QMF was similarly changed to
  allow such unmatched columns to be updated.  The change in QMF
  did not include allowing updates for columns with unmatched
  NULL definitions.
  Additionally, QMF was not properly handling XML columns during
  SAVE DATA and IMPORT processing.
  

Problem conclusion

• Code in QMF SAVE DATA and IMPORT processing was changed to
  allow columns with NULL definitions to be updated with data
  with different NULL definitions.
  
  Code was also added to process XML columns properly.
  

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:

  UK64279

Modules/Macros

• DSQCELTT DSQCEMSG DSQDIMPX DSQDSAVX DSQPNLE
  DXYEHZWN DXYE0172 DXYE1316
  

Fix information

• Fixed component name

  QMF-QUERY MGMT

• Fixed component ID

  566872101

Applicable component levels

• RA10 PSY UK64279

     UP11/01/28 P F101

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.