PI60587: DB2 ADMIN TOOL UNEXPECTED TABLE SPECIFICATION SYNTAX, ADB2PA: THE FOLLOWING STATEMENT COULD NOT BE PARSED

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Line command DDL/GEN or ALTER on a Procedure returns similar
  errors:
     Unexpected table specification syntax
  
     ADB2PA: The following statement could not be parsed :
  
     CREATE PROCEDURE ....
  
         Processing Stored Procedure >name< version
     ADB1932W Parser error - the original DDL will be generated
              for the following object
              Reason code = 28
  or
     GEN /
     ALTER PROCEDURE >name< REPLACE VERSION V1
  
     Token number = 45, Token = TABLE
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use the Line command DDL/GEN or     *
  *                 ALTER on a Procedure.                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: Line command DDL/GEN or ALTER on a      *
  *                      Procedure returns a parser error:       *
  *                                                              *
  *                      Unexpected table specification 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:

  UI38415 UI38416

Modules/Macros

•    ADB2PA
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB10 PSY UI38415

     UP16/06/09 P F606

• RB20 PSY UI38416

     UP16/06/09 P F606

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.