PM19045: DDL AND GEN FAIL FOR SP CONTAINING WITH UR CLAUSE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 Administration Tool for z/OS GEN and DDL line commands fail
  to produce correct DDL for DB2 Stored Procedure ( SP ) that
  contains a WITH UR clause.
  .
  Customer error symptoms appear as:
  .
  Invalid token after WITH keyword - expected keyword CS, UR, RR,
     or RS
  Error occurred when parsing the following stmt :
  .
  CREATE PROCEDURE TRE2634.SP1 (OUT CURRTS TIMESTAMP) LANGUAGE SQL
  QUALIFIER TTDBADM 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
  .
  Token number =     42, Token = UR
  .
  Local test results omit all text between BEGIN and END ,
  inclusive, showing only terminator character, ?
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool         *
  *                 for z/OS who get the following parser        *
  *                 error:                                       *
  *                                                              *
  *                 Invalid token after WITH keyword - expected  *
  *                 keyword CS, UR, RR, or RS                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: The parser did not correctly parse      *
  *                      the isolation clause in a select        *
  *                      statement.                              *
  ****************************************************************
  * RECOMMENDATION: Apply The PTF.                               *
  ****************************************************************
  The parser did not correctly parse the isolation clause
  in a select statement.
  

Problem conclusion

• The parser 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:

  UK62282 UK62283

Modules/Macros

•    ADB2PA
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK62282

     UP10/11/23 P F011

• R720 PSY UK62283

     UP10/11/23 P F011

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.