PH17126: GEN OF VIEW WITH PARMS('/MASK') WITH EMPTY MASK FILE SHOWS COLUMNS IN SELECT CLAUSE AS SCHEMA.TABLENAME.COLUMNAME

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• A GEN on a view using PARMS('/MASK') with an empty MASK
  file, may produce fully qualified column names
  (schema.tablename.columname) in the SELECT clause, instead of
  just the column name.
  For example, a GEN of a view created from the Db2 sample DEPT
  table may show the following:
  CREATE VIEW DSN81210.VDEPT AS
  SELECT ALL DSN81210.DEPT.DEPTNO, DSN81210.DEPT.DEPTNAME,
  DSN81210.DEPT.MGRNO, DSN81210.DEPT.ADMRDEPT
  FROM DSN81210.DEPT ;
  With the fix applied, the GEN output will be as follows:
  CREATE VIEW DSN81210.VDEPT AS
  SELECT ALL DEPTNO, DEPTNAME, MGRNO, ADMRDEPT
  FROM DSN81210.DEPT ;
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the Reverse Engineering (GEN)       *
  *                 function of the DB2 Administration Tool for  *
  *                 z/OS.                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: Generating DDL for Views with an empty  *
  *                      mask generates fully qualified column   *
  *                      names, even though the view was not     *
  *                      created that way.                       *
  ****************************************************************
  Running GEN of a view and specifying an empty mask
  may result in the views column names being fully qualified, even
  though the view was not created that way.
  
  For example, a GEN of a view created from the Db2 sample DEPT
  table may show the following:
  
  CREATE VIEW DSN81210.VDEPT AS
  SELECT ALL DSN81210.DEPT.DEPTNO, DSN81210.DEPT.DEPTNAME,
  DSN81210.DEPT.MGRNO, DSN81210.DEPT.ADMRDEPT
  FROM DSN81210.DEPT ;
  
  With the fix applied, the GEN output will be as
  follows:
  
  CREATE VIEW DSN81210.VDEPT AS
  SELECT ALL DEPTNO, DEPTNAME, MGRNO, ADMRDEPT
  FROM DSN81210.DEPT ;
  
  Note: If the View was initially created by explicitly
  specifying fully qualified column names, the generated
  DDL will retain the fully qualified column names.
  

Problem conclusion

• The issue has been resolved.
  

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:

  UI66080

Modules/Macros

• ADB2RE   ADB2REE  ADB2REZ
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI66080

     UP19/10/30 P F910

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.