PK96017: GEN / DDL AGAINST VIEW WHICH AS A "WITH CS" CLAUSE FAILS WITH "MISSING CHECK AFTER WITH" AND "TOKEN NUMBER = NNN, TOKEN = CS"

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 with a message:
    Missing CHECK after WITH
  
    Error occured when parsing the following stmt :
    Token number =    nnn, Token = CS
  and:
   ADB1847E WARNING : Error parsing DDL VIEW statement. Please
   verify the generated DDL Reason code = 28
  when issued against a VIEW defined with the "WITH CS" clause.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool for z/OS    *
  *                 who generate DDL that contains the           *
  *                 with-clause as part of a select-statement    *
  *                 for DB2 v7 and earlier.                      *
  ****************************************************************
  * PROBLEM DESCRIPTION: A parser error occurred and the         *
  *                      following messages are generated:       *
  *                      Missing CHECK after WITH                *
  *                                                              *
  *                      Error occurred when parsing the         *
  *                      following stmt :                        *
  *                                                              *
  *                        CREATE VIEW "AAA"."AAAA"              *
  *                      ( COL1 ) AS                             *
  *                      SELECT NAME1 FROM "AAA"."BBB" WITH CS   *
  *                                                              *
  *                      Processing Table/View/Alias             *
  *                        AAA.AAAA                              *
  *                      ADB1847E WARNING : Error parsing DDL    *
  *                      VIEW statement. Please verify the       *
  *                      generated DDL                           *
  *                                  Reason code = 28            *
  *                                  AAA.AAAA                    *
  ****************************************************************
  * RECOMMENDATION: Apply The PTF.                               *
  ****************************************************************
  The parser did not support the with-clause in a select-statement
  that is valid only for DB2 v7 and earlier.
  

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
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R720 PSY UK52000

     UP09/11/21 P F911

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.