PM26070: DDL/GEN ON STORED PROCEDURE WITH COMMON-TABLE-EXPRESSION IN INSERT STATEMENT GETS PARSER ERROR

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• In DB2 Administration Tool for z/OS, when GEN/DDL function
  is performed on a Stored Procedure containing
  INSERT INTO tbname ... ( columns ...)
  WITH tbname AS ( columns ...) FROM tbname
  .
  Error generated:
  Syntax error in INSERT statement
  
  Error occurred when parsing the following stmt :
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool         *
  *                 for z/OS who use at least one of             *
  *                 the following in their DDL:                  *
  *                                                              *
  *                 - common-table-expression                    *
  *                 - joined table clause                        *
  *                 - qualified column name                      *
  *                   reference where the qualifier              *
  *                   matches the name of a special              *
  *                   register                                   *
  *                 - window-order-clause in an OLAP             *
  *                   specification                              *
  ****************************************************************
  * PROBLEM DESCRIPTION: The parser did not fully parse the      *
  *                      WITH common-table-expression            *
  *                      in an INSERT statement.                 *
  *                                                              *
  *                      The parser did not correctly parse      *
  *                      a joined table clause                   *
  *                                                              *
  *                      When parsing a qualified column         *
  *                      name reference, where the               *
  *                      qualifier matches a special             *
  *                      register name, the parser stopped       *
  *                      parsing the column name                 *
  *                      reference after the qualifier.          *
  *                      This results in a random parser         *
  *                      error later in the parser processing.   *
  *                                                              *
  *                      In the window-order-clause of the       *
  *                      OLAP specification, NULLS LAST          *
  *                      can be specified without ASC or         *
  *                      DESC.                                   *
  ****************************************************************
  * RECOMMENDATION: Apply The PTF.                               *
  ****************************************************************
  The parser did not fully parse the WITH common-table-
  expression in an INSERT statement.
  
  The parser did not correctly parse a joined table clause.
  
  When parsing a qualified column name reference, where
  the qualifier matches a special register name, the
  parser stopped parsing the column name reference after
  the qualifier.  This results in a random parser error later
  in the parser processing.
  
  In the window-order-clause of the OLAP specification,
  NULLS LAST can be specified without ASC or DESC.
  

Problem conclusion

• The problems have 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:

Modules/Macros

•    ADB2PA
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK63573

     UP11/02/06 P F102

• R720 PSY UK63574

     UP11/02/06 P F102

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.