PK23499: SORT OPTIONS MODIFIED AND SORT FAST COMMAND ADDED

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• 1. Introduces a choice on which sort criteria to use via a
  pop-up window prior to entering panel ETI$EDIT.
     No indicator on panel ETI$DPSC exists.
  .
  2. Sorting by column name (whether it's currently displayed on
     the panel or not) is now possible directly from the option
     line.  Multiple columns can be sorted.  Examples of the
     syntax are as follows:
       a. SORT COLABCD ASC  (when COLABCD could be a column
          outside the current panel display).
       b. SORT COLABCD COLEFGH ASC  (when COLABCD could be a
          currently displayed column and COLEFGH is outside the
          current displayed panel)
       c. SORT COLABCD ASC DOLEFGH DESC
   Note:  When you specify a column name using any of the above
          formats, you may enclose it in single or double quotes,
          or it may be without any quotes.  For example, the
          following commands are equivalent:
             SORT NAME D
             SORT 'NAME' D
             SORT "NAME" D
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Table Editor.                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1. Introduces a choice on which sort    *
  *                       criteria to use via a pop-up window    *
  *                       prior to entering panel ETI$EDIT.      *
  *                       No indicator on panel ETI$DPSC exists. *
  *                      2. Sorting by column name (whether it's *
  *                       currently displayed on the panel or    *
  *                       not) is now possible directly from the *
  *                       option line.  Multiple columns can be  *
  *                       sorted.  Examples of the               *
  *                       syntax are as follows:                 *
  *                       a. SORT COLABCD ASC  (when COLABCD     *
  *                       could be a column outside the current  *
  *                       panel display).                        *
  *                       b. SORT COLABCD COLEFGH ASC  (when     *
  *                       COLABCD could be a currently           *
  *                       displayed column and COLEFGH is        *
  *                       outside the current displayed panel)   *
  *                       c. SORT COLABCD ASC DOLEFGH DESC       *
  *                       Note:  When you specify a column name  *
  *                       using any of the above ormats, you     *
  *                       may enclose it in single or double     *
  *                       quotes, or it may be without any       *
  *                       quotes.  For example, the following    *
  *                       commands are equivalent:               *
  *                          SORT NAME D                         *
  *                          SORT 'NAME' D                       *
  *                          SORT "NAME" D                       *
  ****************************************************************
  * 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:

Modules/Macros

•    ETI$ACES ETI$ADMN ETI$ADM1 ETI$BLOC ETI$BOOT
  ETI$BULD ETI$CAF  ETI$CAFA ETI$COLS ETI$COMM ETI$DELL ETI$DPSC
  ETI$DPTB ETI$DSQL ETI$EDIT ETI$ESTA ETI$EXPL ETI$FORM ETI$INDX
  ETI$INFO ETI$LOAD ETI$LOG  ETI$MAIN ETI$ORBY ETI$PARS ETI$SAVE
  ETI$SMSG ETI$SQLC ETI$STGM ETI$UPDT ETI$ZPAR ETI#CNVT ETI#JUST
  ETI#LIKE ETI#OUT  ETI#OUT2 ETI#SQLC ETI#STCK ETI#STMT ETI@CNUM
  ETI@COLS ETI@CONN ETI@CSCR ETI@DSQL ETI@EXP1 ETI@FIX1 ETI@FORM
  ETI@IOCT ETI@IOID ETI@IOSC ETI@IOTB ETI@LOGR ETI@ORD1 ETI@PREP
  ETI@REM1 ETI@RES1 ETI@ROLB ETI@SCCM ETI@SCGT ETI@SCIT ETI@SCPT
  ETI@SCRL ETI@SCR1 ETI@SFND ETI@SIZ1 ETI@SQLD ETI@SRT1 ETI@SSET
  ETI@SSRT ETI@TCHK ETI@VALD ETI@WDUP ETI@WRIT ETIALLZT ETIA93
  ETICAPST ETICHART ETIDAREA ETIDYNAL ETIHEXE1 ETIHEXE2 ETIHEXE3
  ETIHLI   ETILINKL ETIMSRT  ETINBLKT ETINNUMT ETINPRNT ETIPRNTT
  ETISRTH  ETISRTH1 ETISRTH2 ETISRTH3 ETISRTH4 ETISRTH5 ETISVC26
  ETITOKEN
  

Fix information

• Fixed component name

  DB2 TABLE EDITO

• Fixed component ID

  5697G6500

Applicable component levels

• R130 PSY UK14056

     UP06/05/03 P F605

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.