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

A fix is available

Subscribe

You can track all active APARs for this component.

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 number

    PM74308

  • Reported component name

    WTX COMMON COMP

  • Reported component ID

    5655R9500

  • Reported release

    840

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-10-04

  • Closed date

    2012-11-01

  • Last modified date

    2013-01-14

Modules/Macros

  • DTXADPT  DTXCDRIV DTXCSAMP DTXC3270 DTXDBUTE
    DTXDBUTL DTXDD8A  DTXDD8Q  DTXDLSMP DTXICU   DTXI48QA DTXI48QC
    DTXI48QN DTXI48XA DTXI48XC DTXI48XN DTXLQ22  DTXLX22  DTXMATH
    DTXMQG22 DTXMTSMK DTXMXG22 DTXRESLB DTXRESNM DTXRMGR  DTXRSADP
    DTXRSZOS DTXRUNMD DTXTDFMK DTXTPBSL DTXTPBSP DTXTPSPX DTXV4XML
    DTXXDS4C DTXXMLLB DTXXMLP  DTXXPI   DTX4CICS DTX4C8A  DTX4C8Q
    DTX4FTP  DTX4MQS  DTX4ODBC DTX4SQL  GTXADPT  GTXCSAMP GTXDBUTL
    GTXDLSMP GTXICU   GTXMATH  GTXRESLB GTXRESNM GTXRMGR  GTXRSADP
    GTXRSZOS GTXRUNMD GTXV4XML GTXXDS4C GTXXMLLB GTXXMLP  GTXXPI
    GTX4CICS GTX4FTP  GTX4MQS  GTX4ODBC
    

Fix information

  • Fixed component name

    WTX COMMON COMP

  • Fixed component ID

    5655R9500

Applicable component levels

  • R840 PSY UK83188

       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.



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

z/OS family

Software version:

840

Reference #:

PM74308

Modified date:

2013-01-14

Translate my page

Machine Translation

Content navigation