PK14353: ROLL-UP APAR - ISPF

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• 1. A WHERE clause originally created on panel ETI$DPSC can now
  be
  deleted from panel ETI$DSQL.
  2. "CREATOR LIKE" and "TABLE LIKE" filters on panels ETI$MAIN
  and
  ETI$DPTB now support the use of text enclosed in double-quotes
  (")-
  which will indicate that UPPER CASE conversion is to be avoided
  for
  the text entered.  This allows tables containing lower case
  characters
  in the CREATOR and/or TABLE NAME to be identified.
  3. performing an action to COPY the second-to-last-row AFTER the
  last
  row will no longer result in the new/copied row being placed
  PRIOR to
  the last row.  The new/copied row will now be correctly copied
  AFTER
  the last row.
  4. When editing a table in panel ETI$FORM using un-editable
  characters, edits will no longer be corrupted and/or changed to
  low
  values (X'00').  This resulted from either the data being
  non-displayable, or the total length of the column exceeding the
  value
  of the maximum character display.
  5. On panel ETI$EDIT, an informational message will now be
  displayed
  to indicate the total number of occurrences found as the result
  of a
  FIND ALL command.
  6. The online help for panels ETI$MAIN and ETI$DPTB has been
  updated
  to include information about the proper usage of the underscore
  character in the "Creator Like" and "Table Like" filters.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Table Editor.                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1. A WHERE clause originally created    *
  *                      on panel ETI$DPSC can now be deleted    *
  *                      from panel ETI$DSQL.                    *
  *                      2. "CREATOR LIKE" and "TABLE LIKE"      *
  *                      filters on panels ETI$MAIN and          *
  *                      ETI$DPTB now support the use of text    *
  *                      enclosed in double-quotes (")- which    *
  *                      will indicate that UPPER CASE           *
  *                      conversion is to be avoided for the     *
  *                      text entered.  This allows tables       *
  *                      containing lower case characters in     *
  *                      the CREATOR and/or TABLE NAME to be     *
  *                      identified.                             *
  *                      3. performing an action to COPY the     *
  *                      second-to-last-row AFTER the last row   *
  *                      will no longer result in the new/copied *
  *                      row being placed PRIOR to the last row. *
  *                      The new/copied row will now be          *
  *                      correctly copied AFTER the last row.    *
  *                      4. When editing a table in panel        *
  *                      ETI$FORM using un-editable characters,  *
  *                      edits will no longer be corrupted       *
  *                      and/or changed to low values (X'00').   *
  *                      This resulted from either the data      *
  *                      being non-displayable, or the total     *
  *                      length of the column exceeding the      *
  *                      value of the maximum character display. *
  *                      5. On panel ETI$EDIT, an informational  *
  *                      message will now be displayed to        *
  *                      indicate the total number of            *
  *                      occurrences found as the result of a    *
  *                      FIND ALL command.                       *
  *                      6. The online help for panels ETI$MAIN  *
  *                      and ETI$DPTB has been updated to        *
  *                      include information about the proper    *
  *                      usage of the underscore character in    *
  *                      the "Creator Like" and "Table Like"     *
  *                      filters.                                *
  ****************************************************************
  * 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:

  UK09086

Modules/Macros

•    ETI$ADMN ETI$ADM1 ETI$BLOC ETI$BULD ETI$COLS
  ETI$COMM ETI$DELL ETI$DPSC ETI$DPTB ETI$DPT8 ETI$DSQL ETI$EDIT
  ETI$EXPL ETI$FORM ETI$INDX ETI$LOAD ETI$MAIN ETI$MAI2 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
  ETIBLNKT ETICAPST ETICHART ETIHDPTB ETIHEXE1 ETIHEXE2 ETIHEXE3
  ETIH001  ETINBLKT ETINNUMT ETINPRNT ETIPRNTT ETI14    H25K130J
  

Fix information

• Fixed component name

  DB2 TABLE EDITO

• Fixed component ID

  5697G6500

Applicable component levels

• R130 PSY UK09086

     UP05/11/18 P F511

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.