PK95046: GEN NSP MISSING SEMI-COLON AFTER SQL_PROCEDURE_STATEMENT STORED PROCEDURE "TOKEN = EXCEPTION"

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS GEN function issues the
  message:
    Missing semi-colon after sql_procedure_statement
  
    Error occured when parsing the following stmt :
  with additional message:
  Token number =    nnn, Token = EXCEPTION
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool who use     *
  *                 the GEN or DDL command to generate DDL for   *
  *                 a native SQL procedure that contains a GET   *
  *                 DIAGNOSTICS statement.                       *
  ****************************************************************
  * PROBLEM DESCRIPTION: A parser error starting with the        *
  *                      following text appears and the job      *
  *                      ends with RC=8:                         *
  *                                                              *
  *                      Missing semi-colon after                *
  *                      sql_procedure_statement                 *
  *                                                              *
  *                      Error occurred when parsing the         *
  *                      following stmt :                        *
  *                                                              *
  *                      <one of your native SQL procedure       *
  *                      statement containing a GET              *
  *                      DIAGNOSTICS statement>                  *
  *                      Token number =  nnn, Token = EXCEPTION  *
  ****************************************************************
  * RECOMMENDATION: Apply The PTF.                               *
  ****************************************************************
  The Admin parser did not fully support the alternate syntax of
  EXCEPTION for CONDITION in the GET DIAGNOSTICS statement.
  

Problem conclusion

• The problem has been fixed.
  

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:

Modules/Macros

•    ADB2PA
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R720 PSY UK51207

     UP09/10/27 P F910

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.