PI70010: ETI714E: SQLCODE -420 EDITING FIELD DEFINED AS DECIMAL

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ETI714E: sqlcode -420 editing field defined as DECIMAL.
  For a column defined as DECIMAL (for example DECIMAL(10,0) or
  DECIMAL(15,2), etc.) the largest number that can be inserted is
  99999 and anything greater or equal to 100000 cannot be
  inserted.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of IBM DB2 Table Editor z/OS.          *
  ****************************************************************
  * PROBLEM DESCRIPTION: ETI714E: sqlcode -420 editing field     *
  *                      defined as DECIMAL. For a column        *
  *                      defined as DECIMAL (for example         *
  *                      DECIMAL(10,0) or DECIMAL(15,2), etc.)   *
  *                      the largest number that can be          *
  *                      inserted is 99999 and anything          *
  *                      greater or equal to 100000 cannot be    *
  *                      inserted.                               *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code has been changed to correct this condition.
  

Problem conclusion

• APPLY the PTF.
  

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:

  UI42190

Modules/Macros

•    ETI2DB2  ETI2PEDT
  

Fix information

• Fixed component name

  DB2 TABLE EDITO

• Fixed component ID

  5697G6500

Applicable component levels

• R150 PSY UI42190

     UP16/11/05 P F611

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.