PH12402: ABEND0C9 INSERTING A VALUE OF 4294966745 INTO AN INTEGER COLUMN WHEN USING EXECUTE USING DESCRIPTOR SYNTAX IN REXX

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ABEND0C9 in DSNTZC2I at +01DC at base code level when attempting
  to insert a large value 4294966745 via an EXECUTE USING
  DESCRIPTOR with this value set in the sqldata stem for the
  integer column.
  

Local fix

• Use EXECUTE USING :VAR or a straight INSERT VALUES(...)
  syntax.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All Db2 11 and Db2 12 for z/OS users who     *
  *                 use REXX applications to process data of     *
  *                 type integer.                                *
  ****************************************************************
  * PROBLEM DESCRIPTION: ABEND0C9 in DSNTZC2I inserting a too    *
  *                      large value into an integer column      *
  *                      using EXECUTE USING DESCRIPTOR.         *
  ****************************************************************
  * RECOMMENDATION: Apply corrective PTF when available.         *
  ****************************************************************
  Abend 0C9 inserting a value less than -2147483648 or greater
  than 2147483647into an integer column when using
  EXECUTE USING DESCRIPTOR syntax in REXX.
  If the value of input variable is invalid or too large for the
  target column, SQLCODE should be issued instead of abend.
  

Problem conclusion

• Additional boundary check has been added for data type integer.
  If the value of input variable targeting integer column exceeds
  the range of integer, SQLCODE -302 is issued.
  

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:

  UI63798 UI63799

Modules/Macros

•    DSNTZC2I
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RB10 PSY UI63799

     UP19/07/08 P F907

• RC10 PSY UI63798

     UP19/07/08 P F907

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.