PH19519: ADB7715E THE DDL READER COULD NOT PARSE A DDL STATEMENT TOKEN ONLY (FETCH FIRST ROWS ONLY)

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• FETCH FIRST ROWS ONLY is not recognized and gives an error:
  
  ADB7715E The DDL reader could not parse a DDL statement.
  
  The return code: 16
  
  CREATE VIEW T.VIEW1 AS WITH RUNTST AS
  ( SELECT DBDAY.DATE AS RUNTST FROM T.TABLE DBDAY
  FETCH FIRST ROWS ONLY )  ...
  
  etc..
  
  Token number = 25, Token = ONLY
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the Db2 Administration Tool for     *
  *                 z/OS or Db2 Object Comparison Tool for z/OS  *
  *                 that use DDL with FETCH clauses.             *
  ****************************************************************
  * PROBLEM DESCRIPTION: DDL that contains the FETCH FIRST       *
  *                      ROW(S) ONLY clause fails with a         *
  *                      parser error.                           *
  ****************************************************************
  The following error is returned for a DDL statement with a
  FETCH clause that does not have an optional numeric character
  between FIRST and ROW(S):
  
  ADB7715E The DDL reader could not parse a DDL statement.
  
  The return code: 16
  
  The error statement: partial_DDL_statement
  
  Token number = nn, Token = ONLY
  

Problem conclusion

• The problem is 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:

  UI67941

Modules/Macros

• ADB2PA
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI67941

     UP20/03/02 P F002

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.