PK72504: CM WSLVAL MESSAGE ADB3014E ERROR PROCESSING VIEW IN CREATE STATEMENT: EITHER COLUMN DOES NOT EXIST IN THE TAB(VIEW ON VIEW

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tools Change Management Validate WSL
  issues a message:
  ADB3014E Error processing View aaaaaaa.aaaaaaaa in CREATE
  statement: Either column aaaaaaaaa does not exist in the
  table or the table does not exist.
  
  when the CREATE statement contains a VIEW defined on a VIEW
  which in turn is defined on a VIEW.
  .
  Additional symptoms: msgADB3014E
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Admin & Object Comparison       *
  *                 Tool who uses validation function when       *
  *                 view references  a added view, through       *
  *                 column correlation names.                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: Validation issues wrong error message   *
  *                      ADB3014E,  when a view is  referenced   *
  *                      via an added view.  The added view is   *
  *                      referenced through column correlation   *
  *                      names.                                  *
  ****************************************************************
  * RECOMMENDATION: Apply The PTF.                               *
  ****************************************************************
  When a view references column correlation names,the column list
  generated and updated in dictionary is incorrect. Validation is
  updating the view column names in column list instead of column
  correlation names,which misleads  to error message ADB3014E and
  resulting validation fails with RC 8.
  
  Changes are done so that validation should reference column
  correlation names when provided in a view.
  

Problem conclusion

• The problem has been fixed in  V7.2 only.
  

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:

Modules/Macros

•    ADB2WVL
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R720 PSY UK42530

     UP08/12/24 P F812

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.