PK93074: GEN/DDL STORED PROCEDURE FAILS INVALID TOKEN AFTER = KEYWORD - EXPECTED KEYWORD STATEMENT-INFORMATION-ITEM-NAME DB2_NUMBER_ROWS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS GEN and DDL commands fail
  when processing a stored procedure:
  Invalid token after = keyword - expected keyword
  statement-information-item-name
  Token number =     nn, Token = DB2_NUMBER_ROWS
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users  of DB2  Admin Tool  or DB2  Object    *
  *                 Comparison   Tool  who  use   native  SQL    *
  *                 procedures that contain a GET DIAGNOSTICS    *
  *                 statement.                                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: When  processing  a native  SQL         *
  *                      procedure  that contains  a GET         *
  *                      DIAGNOSTICS statement, a parser         *
  *                      error  can occur  for a missing         *
  *                      statement-information-item-name         *
  *                      keyword on one of the following         *
  *                      tokens:                                 *
  *                                                              *
  *                      DB2_NUMBER_ROWS                         *
  *                      DB2_AUTHENTICATION_TYPE                 *
  *                      DB2_AUTHORIZATION_ID                    *
  *                      DB2_CONNECTION_STATE                    *
  *                      DB2_CONNECTION_STATUS                   *
  *                      DB2_ENCRYPTION_TYPE                     *
  *                      DB2_SERVER_CLASS_NAME                   *
  ****************************************************************
  * RECOMMENDATION: Apply The PTF.                               *
  ****************************************************************
  The parser needs to support the following tokens for a GET
  DIAGNOSTICS statement:
  
  DB2_NUMBER_ROWS
  DB2_AUTHENTICATION_TYPE
  DB2_AUTHORIZATION_ID
  DB2_CONNECTION_STATE
  DB2_CONNECTION_STATUS
  DB2_ENCRYPTION_TYPE
  DB2_SERVER_CLASS_NAME
  

Problem conclusion

• The problem have been fixed. The parser now supports the
  listed tokens in the problem summary.
  

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 UK49451

     UP09/08/27 P F908

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.