PK12508: RC16 WHEN A VIEW CONTAINS FETCH FIRST CLAUSE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 Object Comparison Tool completes compare job with rc16
  when a VIEW contains a FETCH FIRST clause. Error messages
  appear similar to the following:
  .
  SQL stmt not completely parsed
  Error occured when parsing the following stmt :
  .
  CREATE VIEW C717086.VW79443 ( COL1,COL2) AS SELECT COL1,
  COL2 FROM C717086.TB79443 FETCH FIRST 1 ROWS ONLY
  .
  Token number = 00021, Token =FIRST
  .
  Additional symptoms: GEN DDL msgiec212i abend414 rc08 goc2dtc
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users  of  DB2 Administration Tool R710      *
  *                 and Users of DB2 Object Comparison Tool      *
  *                 R710,  who  use  GEN and WSL functions,      *
  *                 may be affected.                             *
  ****************************************************************
  * PROBLEM DESCRIPTION: Parser does not support the syntax      *
  *                      "fetch-first-clause" used in a VIEW.    *
  *                      .*                                      *
  *                      DB2 Object Comparison Tool completes    *
  *                      compare job with RC16 when a VIEW       *
  *                      contains a FETCH FIRST clause.          *
  *                      .* Test Case example                    *
  *                      CREATE VIEW C717086.VW79443 (COL1,COL2) *
  *                      AS SELECT COL1,COL2                     *
  *                      FROM C717086.TB79443                    *
  *                      FETCH FIRST 1 ROWS ONLY;                *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Support for the "fetch-first-clause" syntax in parser was
  absent.
  

Problem conclusion

• Apply the fix.
  

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:

  UK08474

Modules/Macros

•    ADB2PA   ADB2PA3
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R710 PSY UK08474

     UP05/10/28 P F510

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.