PK50138: ADDITIONAL FIXES TO SUPPORT DECFLOAT DATA TYPE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The fixes include:
  a) Invalid error message when inserting or updating with
     DECFLOAT "Error message "Invalid Data Entered for a Numeric
     Data type".
  b) Invalid error message when zooming DECFLOAT field on ETI$FORM
     "ETI093E- This is an invalid ZOOM area" and cursor positioned
     before "Column Name" (header row listing column names.
     Message should be "Expand Not Available for Floating Point
     Numbers".
  c) Truncation may occur when displaying DECFLOAT value.
  d) Null indicator problem when updating DECFLOAT value when
     table column prohibits null columns.
  .
  Other symptoms:  MSGETI093E     ETI093E
  

Local fix

• For issue:
  a) When inserting or updating with DECFLOAT, just continue after
     getting the invalid error message.
  c) Change the Max Char Display value on ETI$MAIN to a larger
     number when truncation occurrs for DECFLOAT value.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Table Editor.                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: The fixes include:                      *
  *                      a. Invalid error message when inserting *
  *                      or updating with DECFLOAT "Error        *
  *                      message "Invalid Data Entered for a     *
  *                      Numeric Data type".                     *
  *                      b. Invalid error message when zooming   *
  *                      DECFLOAT field on ETI$FORM "ETI093E-    *
  *                      This is an invalid ZOOM area" and       *
  *                      cursor positioned before "Column Name"  *
  *                      (header row listing column names).      *
  *                      Message should be "Expand Not Available *
  *                      for Floating Point Numbers".            *
  *                      c. Truncation may occur when displaying *
  *                      DECFLOAT value.                         *
  *                      d. Null indicator problem when updating *
  *                      DECFLOAT value when table column        *
  *                      prohibits null columns.                 *
  ****************************************************************
  * 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:

Modules/Macros

• ETI@LOB
  

Fix information

• Fixed component name

  DB2 TABLE EDITO

• Fixed component ID

  5697G6500

Applicable component levels

• R130 PSY UK32131

     UP07/12/14 P F712

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.