PH21563: DDL/GEN VIEW COLUMN NAME KEYWORD NO QUOTES ADB2PA PARSE ERROR

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Db2 allows tables to have column names that are actually
  keywords, such as "SELECT", "UPDATE", etc.  However,
  if a view is created using such columns, and the column names
  were not put in quotes when the view was creatred, Admin
  Tool DDL/GEN may result in a parser error such as the following:
  
  
  Missing <select-list> or * after SELECT
  
  ADB2PA: The following statement could not be parsed :
  
  CREATE VIEW >viewname< (AVG_INSERT, AVG_DELETE, AVG_SELECT,
  AVG_UPDATE) AS
  SELECT AVG(INSERT), AVG(DELETE), AVG(SELECT), AVG(UPDATE)
  FROM >tablename<
  
  Token number = 30, Token = )
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS DDL generation function.                *
  ****************************************************************
  * PROBLEM DESCRIPTION: DDL generation may fail with a parser   *
  *                      error on views on table columns that    *
  *                      are named after keywords (such as       *
  *                      "SELECT").                              *
  ****************************************************************
  DDL generation may fail with a parser error on views on table
  columns that are named after keywords (such as "SELECT"),
  if such columns were not specified in quotation marks when
  the view was created. For example:
  
  Missing <select-list> or * after SELECT
  
  ADB2PA: The following statement could not be parsed :
  
  CREATE VIEW >viewname< (AVG_INSERT, AVG_DELETE, AVG_SELECT,
  AVG_UPDATE) AS
  SELECT AVG(INSERT), AVG(DELETE), AVG(SELECT), AVG(UPDATE)
  FROM >tablename<
  
  Token number = 30, Token = )
  

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:

  UI67945

Modules/Macros

• ADB2PA
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI67945

     UP20/02/20 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.