PH21624: DB2 ADMIN TOOL, GEN / DDL, 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

• DB2 Admin Tool.  When doing a Gen the following error occurs:
  
  ADB1848W Unformatted DDL will be generated for the following
  view because it could not be parsed. Please verify the DDL.
  
  Reason code = 28
  
  
  The DDL command on the same object, also generates unformatted
  DDL
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
  *                 or Db2 Object Comparison Tool for z/OS that  *
  *                 have DDL with a JOIN clause.                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: The parser fails to resolve names when  *
  *                      a JOIN clause is used in the object     *
  *                      definition.                             *
  ****************************************************************
  The parser throws the following unresolved name error when
  processing DDL with a JOIN clause:
  
  The following statement could not be parsed :
  
  partial_ddl
  
  Unresolved Name Error:
  statement type [statement_type]
  object type [object_type]
  object owner [object_owner]
  object name [object_name]
  column name [column_name]
  
  for example:
  
  CREATE VIEW A.VEMPDEPT(DEPTNO, DEPTNAME, EMPNO, FRSTINIT,
  MIDINIT, LASTNAME, WORKDEPT) AS
  SELECT ALL DEPTNO, DEPTNAME, EMPNO, SUBSTR(FIRSTNME, 1, 1),
  MIDINIT, LASTNAME, WORKDEPT
  FROM A.DEPT
  RIGHT OUTER JOIN A.EMP
  ON WORKDEPT = DEPTNO ;
  

Problem conclusion

• The problem is 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:

  UI67940

Modules/Macros

• ADB2PA
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI67940

     UP20/03/02 P F002 {

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.