PI43880: DB2 ADMINISTRATION TOOL FOR Z/OS WHEN USING DDL COMMAND ON A VIEW MAY RESULT IN MESSAGE : UNEXPECTED TOKEN AFTER AS KEYWORD

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 Administration Tool for z/OS when using DDL/GEN
  command on a VIEW may result in message : Unexpected token
  after AS keyword - expected keyword select- clause
  ADB2PA: The following statement could not be parsed
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use DDL/GEN line command to         *
  *                 generate a VIEW which has the MINUS          *
  *                 keyword in the fullselect statement.         *
  ****************************************************************
  * PROBLEM DESCRIPTION: When using the DDL/GEN line command     *
  *                      on a VIEW which has a MINUS keyword     *
  *                      in the fullselect statement, the        *
  *                      following error is observed:            *
  *                                                              *
  *                      Unexpected token after AS keyword -     *
  *                      expected keyword select- clause         *
  *                      ADB2PA: The following statement         *
  *                      could not be parsed                     *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When using the DDL/GEN line command on a VIEW which has a
  MINUS keyword in the fullselect statement, the following
  error is observed:
  
  Unexpected token after AS keyword - expected keyword select-
  clause
  ADB2PA: The following statement could not be parsed
  

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:

Modules/Macros

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

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA20 PSY UI31745

     UP15/10/06 P F510

• RB10 PSY UI31746

     UP15/10/06 P F510

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.