PM28602: GEN RC04 ADB1848W UNFORMATTED DDL WILL BE GENERATED FOR THE FOLLOWING VIEW BECAUSE IT COULD NOT BE PARSED. IMPLICIT TABLES

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS GEN function issues ends
  RC04 with a message:
  ADB1848W Unformatted DDL will be generated for the following
  view because it could not be parsed. Please verify the DDL.
  The view in question was defined against tables with implicit
  table spaces.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use GEN to generate DDL on a view.  *
  ****************************************************************
  * PROBLEM DESCRIPTION: The DB2 Administration Tool for z/OS    *
  *                      GEN (Generate) function ends with a     *
  *                      RC04 and error message: MSGADB1848W     *
  *                      Unformatted DDL will be generated for   *
  *                      the following view because it could     *
  *                      not be parsed. Please verify the DDL.   *
  *                      The view in question was defined        *
  *                      against tables with implicit table      *
  *                      spaces.                                 *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The qualifier of the view with DB2 control character was used
  in the WHERE clause, and caused the SQLCODE=-204 / SQLCODEN204
  error:
  
  Table not found, Table/View name = view_name
  Table/View creator = view_creator_id.
  

Problem conclusion

• Program has been modified to use a valid qualifier for the view.
  

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   ADB2PA4  ADB2PRP  ADB2REG  ADB2REH
  ADB2WVL
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK71414

     UP11/09/02 P F109

• R720 PSY UK71415

     UP11/09/02 P F109

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.