PH62989: ALLOW DB2 TABLE EDITOR TO DO A MASS CHANGE OF NULLS AND FOR A SPECIFIC COLUMN.

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• Support of mass null change and CHANGE command for a specific
  column.
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of IBM Db2 Table Editor for z/OS       *
  ****************************************************************
  * PROBLEM DESCRIPTION: This APAR introduces the following      *
  *                      enhancements:                           *
  *                      1) Ability to change and set NULL       *
  *                      values using new CHANGENULL and         *
  *                      SETNULL commands.                       *
  *                      2) Ability to change the data in        *
  *                      the specific column.                    *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  This APAR introduces the following
  enhancements:
  1) New commands to change and set NULL values using
  CHANGENULL new-value <colname> <ALL>
  and
  SETNULL old-value  <colname> <ALL> for nullable columns.
  2) CHANGE command updated with ability to specify the
  column:
  CHANGE old-value new-value <column-name> <ALL>
  

Problem conclusion

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:

  UI98741

Modules/Macros

• ETI2CMDP ETI2CONN ETI2CSVE ETI2FEXP ETI2MAIN ETI2MEPL ETI2MSGS
  ETI2PCEP ETI2PDAP ETI2PEDT ETI2PFRM ETI2PHST ETI2PLEX ETI2PLOG
  ETI2PMAN ETI2PRDM ETI2PSAC ETI2PSEL ETI2PSQL ETI2PSUB ETI2PTLS
  ETI2PUST ETI61    ETI6XOPT ETI6XPAN ETI6XPAR ETIHEDIT ETIISPF
  ETIPANEL ETIPCONF ETIPROC  ETIRPT
  

Fix information

• Fixed component name

  DB2 TABLE EDITO

• Fixed component ID

  5697G6500

Applicable component levels

• R150 PSY UI98741

     UP24/10/17 P F410

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.