PI07143: 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

• GEN message ADB1848W Unformatted DDL will be generated for the
  following view because it co uld not be parsed. Please verify
  the DDL. Reason code = 28.
  

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 Administration 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 Administration
  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:

  UI15233

Modules/Macros

• ADB2PA
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB10 PSY UI15233

     UP14/02/20 P F402

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.