PH13238: DDL GEN Object Compare STORED PROCEDURE PARSE ERROR ADB2PA UNEXPECTED TOKEN ADB1932W / msgadb1932w EXPECTED KEYWORD RESULT

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DDL or GEN output of a stored procedure may result in the
  following parse error:
  Unexpected token after FOR keyword - expected keyword RESULT
   ADB2PA: The following statement could not be parsed :
  [unformatted text of stored procedure appears here]
  Token number =    nnn, Token = nn
  ADB1932W Parser error - the original DDL will be generated for
  the following object. Please verify the DDL.
              Reason code = 28
             >procedure name<
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS and DB2 Object Comparison Tool for      *
  *                 z/OS.                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: Reverse engineering program (GEN)       *
  *                      or Object Compare job may fail          *
  *                      with a parser error when                *
  *                      processing a stored procedure           *
  *                      object.                                 *
  ****************************************************************
  Reverse engineering program (GEN) or Object Compare
  job may fail with a parser error when a body of a stored
  procedure contains an ALLOCATE CURSOR statement
  without "RESULT SET" keywords. The error messages
  are as follows:
  
  ADB1932W Parser error - the original DDL will be generated for
  the following object.
  Please verify the DDL Reason code = 28
  object_name
  Unexpected token after FOR keyword - expected
  keyword RESULT
  

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:

  UI65156

Modules/Macros

• ADB2PA
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI65156

     UP19/09/07 P F909

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.