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

Obtain the fix for this APAR.

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 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.