PM00685: GEN OR DDL FOR NSP MSGADB1847E RC28 INVALID TOKEN AFTER FOR KEYWORD - EXPECTED KEYWORD ORDINALITY

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• In DB2 Administration Tool main panel use of option O for Stored
  Procedures, provides list of SP s in panel ADB21O , where GEN or
  DDL command can result in error messages similar to the
  following:
  .
  Invalid token after FOR keyword - expected keyword ORDINALITY
  Error occured when parsing the following stmt :
  CREATE PROCEDURE ECS2H02.ADD_FILE_CHANGEX
  ...
       END MAIN
  .
  ADB1847E WARNING : Error parsing DDL NSP statement. Please
  verify the generated DDL
              Reason code = 28
  Token number =    537, Token = ORDINALITY
  .
  Problem appears for certain NSP ( Native Stored Procedure ) that
  utilizes FOR statement loop keyword.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool for z/OS    *
  *                 who use the GEN or DDL command on a native   *
  *                 SQL procedure that contains a                *
  *                 xml-table-ordinality-column-definition       *
  *                 within the XMLTABLE table function.          *
  ****************************************************************
  * PROBLEM DESCRIPTION: A parser error occurred about a missing *
  *                      ORDINALITY token.                       *
  *                      e.g.                                    *
  *                      Invalid token after FOR keyword -       *
  *                      expected keyword ORDINALITY             *
  *                         :                                    *
  *                      Error occurred when parsing the         *
  *                      following stmt                          *
  *                      ...                                     *
  *                      Token number =    537,                  *
  *                      Token = ORDINALITY  :                   *
  ****************************************************************
  * RECOMMENDATION: Apply The PTF.                               *
  ****************************************************************
  The parser was skipping over the ORDINALITY token in the
  XMLTABLE table function.
  

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   ADB2WVL
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R720 PSY UK53038

     UP09/12/25 P F912

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.