PH65649: SQL FORMATTER ISSUE MERGING "ONLY WITH" INTO A SINGLE WORD

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• After applying the SQL formatter in the SQL Editor, the phrase
  "ONLY WITH" is incorrectly merged into a single word "ONLYWITH"
  in the formatted SQL. This leads to a syntax error.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
  ****************************************************************
  * PROBLEM DESCRIPTION: Formatter incorrectly processes an SQL  *
  *                      SELECT statement that has the FOR FETCH *
  *                      ONLY clause followed by another clause. *
  ****************************************************************
  When Formatter processes an SQL SELECT statement, the FOR FETCH
  ONLY clause might be processed incorrectly and merged with
  the following clause. For example, "FOR FETCH ONLY WITH UR" will
  be formatted as "FOR FETCH ONLYWITH UR".
  

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:

  UO02897

Modules/Macros

• ADB2FMT
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RD10 PSY UO02897

     UP25/04/24 P F504

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.