PH25003: DB2 OBJECT COMPARE: UNEXPECTED <SELECT> SYNTAX IN THE WITH CLAUSE ADB2PA: THE FOLLOWING STATEMENT COULD NOT BE PARSED

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• During compare:
  
  Unexpected <Select> syntax in the WITH clause
  
  ADB2PA: The following statement could not be parsed
  
  Example of invalid DDL (SELECT keyword is missing)
  
  DDL generated:
  
  ORDER BY HIS.SEQ_NB), VALREC AS(EXT_INU_ID, VLD_REC_CT,
  
  DDL source:
  
  ORDER BY HIS.SEQ_NB), VALREC AS(SELECT EXT_INU_ID, VLD_REC_CT,
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the Db2 Object Comparison Tool for  *
  *                 z/OS who use views with an ORDER BY clause.  *
  ****************************************************************
  * PROBLEM DESCRIPTION: Error ADB7955E is returned              *
  *                      when comparing a view that includes     *
  *                      an ORDER BY clause.                     *
  ****************************************************************
  During the compare process, if a view contains an ORDER BY
  clause, a parser error might occur as a result of mishandling by
  the formatter.
  
  For example:
  ORDER BY A.COL1, COL2 AS (SELECT COL3, COL4,
  
  is generated without the SELECT keyword
  ORDER BY A.COL1, COL2 AS (COL3, COL4, ..
  
  The following error is returned:
  ADB7955E ADB2PA Unexpected <Select> syntax in the WITH clause
  ADB7955E ADB2PA: The following statement could not
  be parsed :
  
  CREATE VIEW <Object_name>..
  

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:

  UI70495

Modules/Macros

• ADB2FMT  ADB2PA5
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI70495

     UP20/07/14 P F007

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.