PM42607: GEN PROCEDURE FAILS RC08 WITH MESSAGE 'INVALID TOKEN AFTER FOR KEYWORD - EXPECTED KEYWORD UPDATE-, READ_ONLY-, ETC. CLAUSE'

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS GEN / DDL function issues
  a message:
  Invalid token after FOR keyword - expected keyword update-,
  read_only-, etc. clause
  Error occurred when parsing the following stmt :
  CREATE PROCEDURE <schema>.<procedure-name>
     (OUT CURRTS TIMESTAMP)
      LANGUAGE SQL
      ASUTIME LIMIT 500000
      DYNAMIC RESULT SETS 1
      COMMIT ON RETURN YES
      MODIFIES SQL DATA
  BEGIN
  SELECT CURRENT_TIMESTAMP INTO CURRTS
  FROM SYSIBM.SYSDUMMY1 FOR FETCH ONLY
    WITH UR;
  END#
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use the GEN or DDL command that     *
  *                 results in a stored procedure being          *
  *                 generated.                                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: The DB2 Administration Tool for z/OS    *
  *                      GEN / DDL function issues a message:    *
  *                                                              *
  *                      Invalid token after FOR keyword -       *
  *                      expected keyword update-, read_only -,  *
  *                      etc. clause                             *
  *                      Error occurred when parsing the         *
  *                      following stmt :                        *
  *                                                              *
  *                      CREATE PROCEDURE                        *
  *                      < schema >.< procedure-name >           *
  *                         (OUT CURRTS TIMESTAMP)               *
  *                          LANGUAGE SQL                        *
  *                          ASUTIME LIMIT 500000                *
  *                          DYNAMIC RESULT SETS 1               *
  *                          COMMIT ON RETURN YES                *
  *                          MODIFIES SQL DATA                   *
  *                      BEGIN                                   *
  *                      SELECT CURRENT_TIMESTAMP                *
  *                      INTO CURRTS FROM SYSIBM.SYSDUMMY1       *
  *                      FOR FETCH ONLY WITH UR;                 *
  *                      END#                                    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The "FOR FETCH ONLY" clause in the select statement is not
  parsed correctly.
  

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:

  UK69927 UK69928

Modules/Macros

•    ADB2PA
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK69927

     UP11/08/04 P F108

• R720 PSY UK69928

     UP11/08/04 P F108

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.