PM25498: VIEW CREATED WITH SPECIFIC COLUMNS IN TABLE THEN DROP OF COLUMN IN TABLE DOES NOT DROP COLUMN IN VIEW RESULT SQLCODEN158

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• In DB2 Administration Tool for z/OS, when View contains
  specific columns from table, and column is dropped from
  table using ALC, generated ddl for Create View still
  contains the dropped column resulting in -158.
  .
  Additional Symptoms: sqlcoden158 rc08
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use ALT to delete columns that are  *
  *                 referenced in a view.                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: In DB2 Administration Tool for z/OS,    *
  *                      when a view contains columns that are   *
  *                      dropped from the table using ALT,       *
  *                      generated DDL for CREATE VIEW will      *
  *                      fail with a SQLCODE=-158/SQLCODEN158    *
  *                      when validating WSL:                    *
  *                                                              *
  *                      DSNT408I SQLCODE = -158, ERROR:         *
  *                      THE NUMBER OF COLUMNS SPECIFIED         *
  *                      FOR THE VIEW OR TABLE IS NOT THE        *
  *                      SAME AS THE NUMBER OF COLUMNS           *
  *                      SPECIFIED BY THE FULLSELECT,            *
  *                      OR THE NUMBER OF COLUMNS SPECIFIED      *
  *                      IN THE CORRELATION CLAUSE IN A FROM..   *
  *                      SQLSTATE 42811                          *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The number of columns in the CREATE VIEW statements do not match
  the number of columns in the table. Validate Work Statement
  Lists ( WSL ) will fail with a SQLCODE=-158/SQLCODEN158.
  

Problem conclusion

• Support to validate the number of view columns when validating
  WSL was added.
  

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:

  UK66734

Modules/Macros

• ADB2WVL
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK66734

     UP11/04/15 P F104

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.