PM74315: ABEND S0C4 WHEN TRYING TO INSERT DATA WHERE SOME OF THE COLUMNS ARE NULL INTO A DB2 TABLE ON Z/OS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• A map that is executed on z/OS that attempts to insert (or
  update) data in a DB2 table, where the data being inserted
  contains a NULL for any column could ABEND.
  

Local fix

• WTXCQ - WTX00041503
  PB / PB
  Circumvention: Design the insert and update statements so that
  NULLs are not sent.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All users of WebSphere Transformation        *
  *                 Extender V8.4                                *
  ****************************************************************
  * PROBLEM DESCRIPTION: ABEND S0C4 WHEN TRYING TO INSERT DATA   *
  *                      WHERE SOME OF THE COLUMNS ARE NULL      *
  *                      INTO A DB2 TABLE ON Z/OS                *
  ****************************************************************
  * RECOMMENDATION: Apply this maintenance                       *
  ****************************************************************
  ABEND S0C4 WHEN TRYING TO INSERT DATA WHERE SOME OF THE COLUMNS
  ARE NULL INTO A DB2 TABLE ON Z/OS
  

Problem conclusion

• ABEND S0C4 WHEN TRYING TO INSERT DATA WHERE SOME OF THE COLUMNS
  ARE NULL INTO A DB2 TABLE ON Z/OS
  

Temporary fix

Comments

APAR Information

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

  PM74308

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

  UK83190

Modules/Macros

•    DTXCMDSV DTXPAGE  DTXPROF  DTX840   GTXCMDSV
  GTXPAGE  GTXPROF  GTX840
  

Fix information

• Fixed component name

  WTX COMMAND SER

• Fixed component ID

  5655R9501

Applicable component levels

• R841 PSY UK83190

     UP12/11/07 P F211

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.