PH30193: DB2 ADMIN TOOL: DDL COMMAND FAILS ON SQL STORED PROC. WHEN AN ADDITIONAL VARIABLE IS DECLARED AFTER SQLSTATE.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Db2 Admin Tool: DDL command on SQL stored procedure gets an
  error
  
  IKT00405I SCREEN ERASURE CAUSED BY ERROR RECOVERY PROCEDURE
  
  Unexpected token after SQLSTATE keyword - expected keyword CHAR
  or CHARACTER
  
  ADB2PA: The following statement could not be parsed : Alter
  Procedure schema.name:
  
  Parser fails when an additional variable appears after SQLSTATE
  declaration.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the Db2 Administration Tool for     *
  *                 z/OS reverse engineering (GEN) function.     *
  ****************************************************************
  * PROBLEM DESCRIPTION: Generating DDL for a store procedure    *
  *                      with the SQLSTATE keyword fails with a  *
  *                      parser error.                           *
  ****************************************************************
  DDL generation for a stored procedure might fail if the DDL for
  the procedure includes an SQLSTATE declaration combined with
  additional variables.
  
  Example declaration that might cause the error:
  DECLARE SQLSTATE , P_SQLSTATE CHAR( 05) DEFAULT '00000' ;
  
  Example error message:
  Unexpected token after SQLSTATE keyword - expected keyword
  CHAR or CHARACTER
  

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:

  UI73386

Modules/Macros

• ADB2PA
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI73386

     UP21/02/01 P F101

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.