PM93113: GEN MESSAGE ADB1848W UNFORMATTED DDL WILL BE GENERATED FOR THE FOLLOWING VIEW BECAUSE IT COULD NOT BE PARSED.

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:
  ADB1848W Unformatted DDL will be generated for the following
  view because it could not be parsed. Please verify the DDL.
  Reason code = 28
  >schema<.>view<
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS.                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: If a view contains a common table       *
  *                      expression with no explicit column      *
  *                      names, when the user uses the Generate  *
  *                      (GEN) line command on the view to       *
  *                      generate the DDL, the DB2 Admin Tool    *
  *                      issues a warning message ADB1848W /     *
  *                      msgADB1848W:                            *
  *                                                              *
  *                      ADB1848W Unformatted DDL will be        *
  *                      generated for the following view        *
  *                      because it could not be parsed.         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  If a view contains a common table expression with no explicit
  column names, when the user uses the Generate (GEN) line
  command on the view to generate the DDL, the DB2 Admin Tool
  issues a warning message ADB1848W / msgADB1848W:
  
  ADB1848W Unformatted DDL will be generated for the
  following view because it could not be parsed.
  

Problem conclusion

• Problem 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:

Modules/Macros

•    ADB2PA
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UI13021

     UP13/11/30 P F311

• RA20 PSY UI13020

     UP13/11/30 P F311

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.