IBM Support

PK92986: NULL VALUE ARE INSERTED IN THE DB , ERROR SQLCODE = -310, ERROR:DECIMAL HOST VARIABLE OR PARAMETER 8 CONTAINS NON-DECIMAL DATA

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • customer have change his type tree decimal item to binary packed
    decimal .
    
    Customer have try the test case using packed decimal with
    modified type and map complet successfully .
    
    The problem is that no value are inserted in DECIMAL column now
    and all get a NULL value
    
    This is what show the trace  :
     00000000: NULL
    0 DSNT408I SQLCODE = -310, ERROR:  DECIMAL HOST VARIABLE OR
    PARAMETER 8
    CONTAINS NON-DECIMAL DATA                         DSNT408I SQ
     LCODE = -310, ERROR:  DECIMAL HOST VARIABLE OR PARAMETER 8
    CONTAINS
    NON-DECIMAL DATA
    0 DSNT418I SQLSTATE   = 22023 SQLSTATE RETURN CODE
    DSNT418I SQ
     LSTATE   = 22023 SQLSTATE RETURN CODE
    0 DSNT415I SQLERRP    = DSNXRIHB SQL PROCEDURE DETECTING ERROR
    DSNT415I SQ
     LERRP    = DSNXRIHB SQL PROCEDURE DETECTING ERROR
    0 DSNT416I SQLERRD    = -235  0  0  -1  0  0 SQL DIAGNOSTIC
    INFORMATION
    DSNT416I SQ
     LERRD    = -235  0  0  -1  0  0 SQL DIAGNOSTIC INFORMATION
    0 DSNT416I SQLERRD    = X'FFFFFF15'  X'00000000'  X'00000000'
    X'FFFFFFFF'  X'00000000'  X'00000000' SQL DIAGNOSTIC
    DSNT416I SQ
     LERRD    = X'FFFFFF15'  X'00000000'  X'00000000'  X'FFFFFFFF'
    X'00000000'  X'00000000' SQL DIAGNOSTIC
    
    the product was trying to convert packed decimal to packed
    decimal ending up always with an empty (NULL) field. Now doesn't
    try to convert packed decimal.
    

Local fix

  • WTX00031480
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All V8.1 WTX Users                           *
    ****************************************************************
    * PROBLEM DESCRIPTION: NULL VALUE ARE INSERTED IN THE DB,      *
    *                      ERROR SQLCODE = -310, ERROR: DECIMAL    *
    *                      HOST VARIABLE OR PARAMETER 8   CONTAINS *
    *                      NON -DECIMAL DATA                       *
    ****************************************************************
    * RECOMMENDATION: APPLY THIS MAINTENANCE                       *
    ****************************************************************
    The fix for this APAR will be included in the PTF for APAR
    PK97806.
    

Problem conclusion

  • The fix for this APAR will be included in the PTF for APAR
    PK97806.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PK92986

  • Reported component name

    WTX APP PGM ZOS

  • Reported component ID

    5655R9502

  • Reported release

    812

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2009-08-03

  • Closed date

    2009-10-26

  • Last modified date

    2009-11-04

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

    PK92705

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

Modules/Macros

  • DTXCTST  DTXCXIT  DTXDPAXB DTXIMQS  DTXIMS
    DTXIMSIT DTXISQL  DTXKTST  DTXKXIT  DTXMAPLD DTXMPULD DTXPSB1
    DTXPSB2  DTXSDK   DTXTEST  DTXTESTA DTXTESTC DTX810AD DTX810CI
    DTX810DB DTX810IC DTX810IK DTX810IU DTX810KB DTX810KC DTX810KD
    DTX810KI DTX810KL DTX810KM DTX810KP DTX810KS DTX810KU DTX810KZ
    DTX810LD DTX810ML DTX810MP DTX810NM DTX810RK DTX810RL DTX810RM
    DTX810RS DTX810RU DTX810RZ DTX810TB DTX810TK DTX810XB DTX810XC
    DTX810XK DTX810XL DTX810XM DTX8104C DTX8104M DTX8104S DTX8105C
    DTX8105L DTX8105M DTX8105N DTX8105S
    

Fix information

  • Fixed component name

    WTX APP PGM ZOS

  • Fixed component ID

    5655R9502

Applicable component levels

  • R812 PSY UK51414

       UP09/10/29 P F910

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.

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSVSD8","label":"WebSphere Transformation Extender"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.1","Edition":"","Line of Business":{"code":"LOB02","label":"AI Applications"}},{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.1","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
04 November 2009