PK20816: ENHANCE EDITS ALLOWED TO ROWS WITH TIME COLUMNS CONTAINING SECONDS WHEN THE SUBSYSTEM DEFAULT IS TIME=USA

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• Currently rows with TIME columns containing seconds cannot be
  updated if the subsystem default is TIME=USA.  This enhancement
  allows editing under these conditions:
   - non-time columns can now be updated/deleted
   - time value columns that contain 0 seconds or null values can
     now be updated/deleted
  .
  Attempts to edit a time value containing seconds will not be
  allowed.  The new message, MSGETI088E :
   ETI088E- Time column contains seconds and can not be updated
  will be displayed in these cases.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Table Editor.                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: Currently rows with TIME columns        *
  *                      containing seconds cannot be updated    *
  *                      if the subsystem default is TIME=USA.   *
  *                      This enhancement allows editing under   *
  *                      these conditions:                       *
  *                       - non-time columns can now be          *
  *                         updated/deleted                      *
  *                       - time value columns that contain 0    *
  *                         seconds or null values can           *
  *                         now be updated/deleted               *
  *                      Attempts to edit a time value           *
  *                      containing seconds will not be allowed. *
  *                      The new message, MSGETI088E :           *
  *                      ETI088E- Time column contains seconds   *
  *                      and can not be updated                  *
  *                      will be displayed in these cases.       *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code has been changed to correct this condition.
  

Problem conclusion

Temporary fix

Comments

• APPLY the PTF.
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UK12462

Modules/Macros

•    ETI$ADMN ETI$ADM1 ETI$BLOC ETI$BULD ETI$COLS
  ETI$COMM ETI$DELL ETI$DPSC ETI$DPTB ETI$DSQL ETI$EDIT ETI$EXPL
  ETI$FORM ETI$INDX ETI$LOAD ETI$MAIN ETI$PARS ETI$SAVE ETI$STGM
  ETI$UPDT ETI@CONN ETI@IOCT ETI@IOID ETI@IOSC ETI@IOTB ETI@PREP
  ETI@TCHK ETI@VALD ETI@WDUP ETI@WRIT ETIALLZT ETICAPST ETICHART
  ETIHEXE1 ETIHEXE2 ETIHEXE3 ETINBLKT ETINNUMT ETINPRNT ETIPRNTT
  ETI08    ETI13
  

Fix information

• Fixed component name

  DB2 TABLE EDITO

• Fixed component ID

  5697G6500

Applicable component levels

• R130 PSY UK12462

     UP06/03/11 P F603

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.