PM28617: GEN ADB1848W UNFORMATTED DDL WILL BE GENERATED FOR THE FOLLOWING VIEW BECAUSE IT COULD NOT BE PARSED. PLEASE VERIFY THE DDL.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS GEN function issues a
  message:
  ADB1847E WARNING : Error parsing DDL VIEW or TABLE statement.
  Please verify the generated DDL Reason code = 28
  or:
  ADB1848W Unformatted DDL will be generated for the following
  view because it could not be parsed. Please verify the DDL.
  Reason code = 28
  when processing a VIEW.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool for z/OS    *
  *                 that define DB2 objects using a              *
  *                 common-table expression.                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: A parser error occurs when              *
  *                      DB2 Administration Tool attempts to     *
  *                      parse a DDL statement that contains all *
  *                      of the following:                       *
  *                      - a common-table expression             *
  *                      - a correlation name on a common-table  *
  *                      expression                              *
  *                      - a reference to a column of a          *
  *                      common-table expression where the       *
  *                      qualifier of the column is the          *
  *                      correlation name for the common-table   *
  *                      expression                              *
  *                                                              *
  *                      example:                                *
  *                      -- COMMON_TB is a common-table          *
  *                      --     expression                       *
  *                      -- BT is a correlation name for the     *
  *                      --     COMMON_TB common-table           *
  *                      --     expression                       *
  *                      -- BT.C1 is a qualified reference to    *
  *                      --     a column of a common-table       *
  *                      --     expression, using the            *
  *                      --     correlation name as the          *
  *                      --     qualifier.                       *
  *                      CREATE VIEW PM28617_VW1 AS              *
  *                        WITH COMMON_TB AS (                   *
  *                            SELECT A.C1, A.C2, A.C3           *
  *                                FROM PM28617_TB1 A            *
  *                        )                                     *
  *                        SELECT BT.C1, BT.C2                   *
  *                          FROM COMMON_TB BT                   *
  *                          WHERE BT.C1 = 1                     *
  *                            AND BT.C2 = 2                     *
  *                            AND BT.C3 = 3;                    *
  ****************************************************************
  * RECOMMENDATION: Apply The PTF.                               *
  ****************************************************************
  The ADB1847E parser error message is issued when using
  DB2 Administration Tool v7.2, and the ADB1848W parser error
  message is when using DB2 Administration Tool v10.
  
  This happens when DB2 Administration Tool attempts to parse
  a DDL statement that contains a common-table expression.
  

Problem conclusion

• The problem has been fixed.
  

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
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK63573

     UP11/02/06 P F102

• R720 PSY UK63574

     UP11/02/06 P F102

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.