PM90633: MESSAGE 'MISSING SEMI-COLON AFTER SQL-PROCEDURE-STATEMENT IN IF STATEMENT' WHEN PROCESSING CREATE PROCEDURE STATEMENT.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS' program ADB2PA issues
  a message:
  Missing semi-colon after sql-procedure-statement in IF statement
  
  ADB2PA: The following statement could not be parsed :
  
  for a CREATE PROCEDURE statement.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Object Comparison Tool for  *
  *                 z/OS who compare two Native Stored           *
  *                 (NSP) when the source is from DDL and the    *
  *                 stored procedure in the source only uses     *
  *                 the sql-routine-body statement instead       *
  *                 of BEGIN sql-routine-body END and the        *
  *                 target is generated from the DB2 catalog     *
  *                 automatically.                               *
  ****************************************************************
  * PROBLEM DESCRIPTION: The DB2 Object Comparison Tool for      *
  *                      z/OS ADB2PA program issues a message:   *
  *                                                              *
  *                      Missing semi-colon after                *
  *                      sql-procedure-statement in IF           *
  *                      statement                               *
  *                                                              *
  *                      ADB2PA: The following statement         *
  *                      could not be parsed :                   *
  *                                                              *
  *                      for a CREATE PROCEDURE statement.       *
  *                                                              *
  *                      Example:                                *
  *                                                              *
  *                      #SET TERMINATOR ?                       *
  *                      CREATE PROCEDURE XXXX                   *
  *                      ...                                     *
  *                      sql-routine-body?                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When parsing the native stored procedure the following error
  message is displayed:
  
  'Missing semi-colon after sql-procedure-statement in IF
  statement'
  
  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:

  UK95887 UK95888

Modules/Macros

• ADBCDTS  ADBCRCM  ADB2ISQ
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK95887

     UP13/07/18 P F307

• RA20 PSY UK95888

     UP13/07/18 P F307

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.