PI79944: DB2 ADMINISTRATION TOOL UNABLE TO PARSE THE DDL DEFINITION FOR A XML-BASED VIEW

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Executing line command GEN or DDL or a Database Compare when
  scope includes a XML view, DB2 Administration Tool is unable
  to parse the DDL definition:
  
  Unexpected token after 0 keyword - expected keyword ")"
  
   ADB2PA: The following statement could not be parsed :
  
   CREATE VIEW viewname (...)
   AS SELECT ..., XMLINFO.*
   FROM tablename INNER JOIN
   XMLTABLE(...) AS "XMLINFO"
  
   Token number =     47, Token = PATH
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool for         *
  *                 z/OS who use the parser (e.g., via a         *
  *                 GEN or DDL command), on a view               *
  *                 containing an xmltable function.             *
  ****************************************************************
  * PROBLEM DESCRIPTION: If the xmltable expression has a        *
  *                      DEFAULT followed by a PATH, a parsing   *
  *                      error occurs.                           *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  DB2 Admin Tool is unable to parse the DDL definition of a view
  with an xmltable function containing a DEFAULT followed by a
  PATH, and a DDL or GEN command on such a view fails with the
  following error:
  
  (Unexpected token after 0 keyword - expected keyword ")"
  ADB2PA: The following statement could not be parsed :
  CREATE VIEW viewname (...)
  AS SELECT ..., XMLINFO.*
  XMLTABLE(...) AS "XMLINFO"
  
  Token number = 47, Token = PATH
  

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:

  UI47922

Modules/Macros

•    ADB2PA
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI47922

     UP17/06/13 P F706

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.