PM84458: GEN OF SQL NSP FAILS RC8 RC08 MSG1933E PARSER ERROR ON TABLE LIKE EXPRESSION

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 Administration Tool for z/OS fails on GEN of SQL SP ( Stored
  Procedure ) with error messages similar to:
  .
  Missing ( after TABLE(function
  .
  ADB2PA: The following statement could not be parsed :
  .
  CREATE PROCEDURE <spname>
  ( IN N TABLE LIKE <tablename>  AS LOCATOR,
    IN O TABLE LIKE <tablename>  AS LOCATOR   )
  .
            Processing Stored Procedure <spname> version V1
  ADB1933E Parser error - GEN cannot complete the request. An SQL
           comment containing the original DDL will be generated.
              Reason code = 8
              <spname>
  .
  Token number =    188, Token = LIKE
  .
  Additional search keywords: GENERATE DDL PANEL ADB21O
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use the Generate (GEN) line         *
  *                 command to generate DDL for a SQL stored     *
  *                 procedure.                                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: When using the GEN line command on a    *
  *                      SQL Stored Procedure the following      *
  *                      error ADB1933E / msgadb1933E occurs:    *
  *                                                              *
  *                      Missing '(' after 'TABLE(function'      *
  *                      ADB2PA: The following statement         *
  *                      could not be parsed :                   *
  *                                                              *
  *                      CREATE PROCEDURE >spname<               *
  *                      (IN N TABLE LIKE >tablename<            *
  *                             AS LOCATOR,                      *
  *                        IN O TABLE LIKE >tablename<           *
  *                             AS LOCATOR)                      *
  *                                                              *
  *                      Processing Stored Procedure             *
  *                      >spname< version V1                     *
  *                      ADB1933E Parser error - GEN             *
  *                      cannot complete the request.            *
  *                               An SQL comment containing      *
  *                               the original DDL will          *
  *                               be generated.                  *
  *                      Reason code = 8 >spname<                *
  *                      Token number =    188,                  *
  *                      Token = LIKE ))                         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Program missing logic to parse DB2 table-locator-reference
  syntax.
  

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:

  UK94291 UK94292

Modules/Macros

• ADB2PA
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK94291

     UP13/05/16 P F305

• RA20 PSY UK94292

     UP13/05/16 P F305

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.