PH46375: ADMIN TOOL: DDL GENERATION WITH MASK IS NOT GENERATING DDL

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Admin Tool:  DDL Generation with Mask is not generating DDL
  
  
  DESCRIPTION:  When DDL generation is called with Mask option
  'YES', GEN cannot complete the request. This is due to a parser
  error, where the parser is having trouble tokenizing the view
  statement, specifically because of a word that starts with a
  "_". The fix will be to have the parser be able to read this
  correctly.
  

Local fix

• na
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
  *                 who process SQL statements with a SELECT *   *
  *                 clause that includes a subselect.            *
  ****************************************************************
  * PROBLEM DESCRIPTION: SQL parsing does not completely support *
  *                      a subselect nested within a SELECT *    *
  *                      clause. Certain subselects in this      *
  *                      scenario cause an error while parsing   *
  *                      the statement and may result in         *
  *                      message MSGADB1847 being issued.        *
  ****************************************************************
  SQL parsing is updated to properly support an SQL
  statement with a SELECT * clause that includes a subselect.
  
  Keywords:  ADB1847E MSGADB1847E
  

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:

  UI83662 UI83663

Modules/Macros

• ADB27AC  ADB28MC  ADB2CID  ADB2CM1  ADB2CM3  ADB2CME  ADB2CMF
  ADB2CMO  ADB2CMP  ADB2CMR  ADB2CMS  ADB2CMT  ADB2CMU  ADB2FMT
  ADB2MSK  ADB2MSQ  ADB2PA   ADB2PA3  ADB2PA4  ADB2PA5  ADB2PA6
  ADB2PA7  ADB2REG  ADB2REH  ADB2REM  ADB2WCL  ADB2WIN  ADB2WVL
  ADBASW   ADBCCM   ADBCCMM  ADBCDTS  ADBCEST  ADBCHST  ADBCRCR
  ADBCSPG  ADBDAT   ADBDK    ADBLI    ADBNSPB  ADBPA    ADBPA1
  ADBTEP2  ADBTEPI  ADBTEPR  ADBTEPU  ADBV99
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI83662

     UP22/12/13 P F212

• RD10 PSY UI83663

     UP22/12/13 P F212

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.