PH41533: GEN: ERROR GENERATING DDL VIEW "MISSING <SELECT-LIST> OR * AFTER SELECT" ADB2PA STATEMENT COULD NOT BE PARSED

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The following error may be encountered when generating DDL For a
  view:
  
  Missing <select-list> or * after SELECT
   ADB2PA: The following statement could not be parsed :
  
  This may occur when the original DDL for the view selects a
  column which is named after a Db2 keyword. In this case, GEN
  will output the original DDL stored in the Db2 catalog.
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the Db2 Administration Tool for     *
  *                 z/OS Reverse Engineering (GEN) function      *
  ****************************************************************
  * PROBLEM DESCRIPTION: Error ADB2PA occurred when running GEN  *
  *                      on a view.                              *
  ****************************************************************
  When issuing GEN on a view, the following error is
  returned:
  
  Missing <select-list> or * after SELECT
   ADB2PA: The following statement could not be parsed
  
  This may occur when the original DDL for the view selects a
  column which is named after a Db2 keyword. In this case, GEN
  will output the original DDL stored in the Db2 catalog.
  

Problem conclusion

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

  UI78995

Modules/Macros

• ADB2PA
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI78995

     UP22/01/25 P F201

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.