PK18006: SQLCODEN204 FOR VIEW DDL WHEN A 'RUN SQLID' VALUE IS SPECIFIED ON PANEL GOC5 'GENERATE COMPARE JOBS'

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 Object Comparision Tools produces incorrect VIEW DDL for a
  view with both unqualified column name(s) and a sub-select
  resulting in a SQLCODEN204 -204.
  .
  Additional symptom: sqlcode204
  

Local fix

• Manually correct VIEW DDL.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool and users   *
  *                 of DB2 Object Comparison Tool, who use the   *
  *                 CREATE VIEW statements, may be affected.     *
  ****************************************************************
  * PROBLEM DESCRIPTION: SQLCODEN204 for VIEW DDL  was returned  *
  *                      when a 'RUN SQLID' value was specified  *
  *                      on panel GOC5 'GENERATE COMPARE JOBS'.  *
  *                      .*                                      *
  *                      DB2  Object  Comparision Tool  produced *
  *                      incorrect VIEW DDL for a view with both *
  *                      unqualified  column  name(s) and a sub- *
  *                      select resulting in a SQLCODEN204 -204. *
  *                      .*                                      *
  *                      Incorrect  VIEW DDL  was produced for a *
  *                      view which had both unqualified columns *
  *                      and one or more sub-select resulting in *
  *                      a SQLCODEN204 (-204) error as the table *
  *                      in  the  latest  sub-select was used to *
  *                      qualify the column.                     *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  See Problem Description.
  

Problem conclusion

• Incorrect VIEW DDL was produced for a view which had both
  unqualified columns and one or more sub-select.
  .*
  The reported problem has been corrected.
  

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

•    ADB2PA   ADB2PA3
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R710 PSY UK11950

     UP06/03/01 P F602

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.