PK16080: SQLCODE100 AND ETI097E

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Erroneously generated error msg
  
      ETI097E - A row has either been changed or deleted
                by another user and cannot be updated.
   SQL CODE +100
  
  
  Can occur when the default time format is set to USA (TIME=USA).
  This means that ETI will display the time in HH:MM am/pm format,
  rather than HH:MM:SS format. This can cause a loss of precision,
  and the above error.
  
  This fix will detect and display an error message when the above
  condition is detected
  
  OTHER KEYWORDS: +100 ETI1097
  

Local fix

• ETI is in a position where it can't edit these rows. Since
  TIME=USA is selected, there is data in this time field that
  exists, but is not shown on the screen. ETI follows strict rules
  of not updating data it can't see.
  
  Here are a couple of workarounds:
  1) set all seconds to zero, if you truly don't
     need this data
  2) change the subsystem away from TIME=USA.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Table Editor.                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: Erroneously generated error msg         *
  *                                                              *
  *                          ETI097E - A row has either been     *
  *                       changed or deleted by another user     *
  *                       and cannot be updated.                 *
  *                       SQL CODE +100                          *
  *                                                              *
  *                      Can occur when the default time format  *
  *                      is set to USA (TIME=USA). This means    *
  *                      that ETI will display the time in       *
  *                      HH:MM am/pm format, rather than         *
  *                      HH:MM:SS format. This can cause a loss  *
  *                      of precision, and the above error.      *
  *                      This fix will detect and display an     *
  *                      error message when the above condition  *
  *                      is detected                             *
  ****************************************************************
  * 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:

  UK10148

Modules/Macros

•    ETI$EDIT ETI@WRIT ETI13
  

Fix information

• Fixed component name

  DB2 TABLE EDITO

• Fixed component ID

  5697G6500

Applicable component levels

• R130 PSY UK10148

     UP05/12/17 P F512

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.