PK55745: SQLCODE151 CAN OCCUR WHEN UPDATING DATA WITH EMBEDDED SPACES

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• SQLCODE 151 can occur when attempting to perform an update and
  table data contains blank data or data with embedded spaces.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Table Editor.                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: SQLCODE 151 can occur when attempting   *
  *                      to perform an update and table data     *
  *                      contains blank data or data with        *
  *                      embedded spaces.                        *
  ****************************************************************
  * 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:

  UK32131

Modules/Macros

• ETI$BLOC ETI$BULD ETI$COLS ETI$CONV ETI$EDIT
  ETI$EXPL ETI$FORM ETI$MAIN ETI$PARS ETI$STGM ETI$UPDT ETI#BND2
  ETI@LOB  ETI@PREP ETI@WDUP ETI@WRIT
  

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.