PI18406: ADD SUPPORT FOR HIDDEN COLUMN (INSERT, MOVE AND REPEAT) COMMAND

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ADD SUPPORT FOR INSERTING A HIDDEN COLUMN; REMOVING OR ADDING HI
  DDEN ATTRIBUTE TO A COLUMN; AND SUPPORT FOR MOVE AND REPEAT LINE
  COMMANDS AGAINST A HIDDEN COLUMN.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS 'ALT Alter Table' (ALT) function who    *
  *                 want to insert, move, or repeat hidden       *
  *                 columns, or who want to add or remove the    *
  *                 hidden attribute for a column.               *
  ****************************************************************
  * PROBLEM DESCRIPTION: The following are not supported         *
  *                      within the ALT process:                 *
  *                                                              *
  *                      1. Inserting a hidden column            *
  *                      2. Issuing the "M" (move) line          *
  *                         command against a hidden column.     *
  *                      3. Issuing the "R" (repeat) line        *
  *                         command against a hidden column.     *
  *                      4. Adding or removing the hidden        *
  *                         attribute to or from a column.       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The following enhacements are delivered:
  
  Inserting a hidden column is allowed:
  -  Executing line command "I- Insert" to insert a column on
     panel ADB27C 'ALTER Table' followed by line command
     "U"/"UP - Update" to set the "HIDDEN" attribute to "YES"
     on panel ADB26CTU 'ALTER Table'.
  
  Repeating a hidden column is allowed:
  - Execute line command "R-Repeat" to repeat a hidden column
    on panel ADB27C 'ALTER Table'.
  
  Updating to/from hidden column is allowed:
  - Execute line command "U"/"UP - Update" on panel
    ADB27C 'ALTER Table' to update a non-hidden column
    to a hidden column by setting the "HIDDEN" attribute
    to "YES" or "NO" on panel ADB26CTU 'ALTER Table'.
  
  Rearranging hidden columns is allowed:
  - Execute line command "M- Move" against a hidden column
    on panel ADB27C 'ALTER Table' to move the column before
    or after another column of the table, thus causing the
    rearrangement of columns in the table.
  

Problem conclusion

• Enhancements delivered.
  
  The following new message ADB587E is added
  
  ADB587E  The HIDDEN attribute is not allowed for a
  column defined as ROWID.
  
  Explanation:
  If a column is defined with a ROWID data type, then the
  column can not be specified as HIDDEN.
  System action:
  Processing stops.
  User response:
  Either change the HIDDEN attribute to NO, or specify a
  different column type.
  

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:

  UI20141

Modules/Macros

•    ADBCDTS  ADBEALT  ADB2CMT  ADB26CTU ADB27C
  ADB27CA  ADB27CAA ADB27CMR ADB27C0  ADB58
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB10 PSY UI20141

     UP14/08/01 P F407

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.