PI11431: ADB1847E A PARSER ERROR OCCURRED FOR THE FOLLOWING VIEW. GEN CANNOT COMPLETE THE REQUEST. REASON CODE = 8. AND ADB1873E RC24

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS' GEN function, when used
  with 'Use Masking' YES on panel ADB2GEN 'Generate SQL from DB2
  catalog' issues a message:
  ADB1847E A parser error occurred for the following view. GEN
  cannot complete the request.
  Reason code = 8
  >schema<.>view<
  ADB1873E Processing ended but not all supplied catrows were used
  Reason code = 24
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use the Generate (GEN) function     *
  *                 to generate a view which has multiple        *
  *                 common table expressions.                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: The GEN function, when used with 'Use   *
  *                      Masking' = YES on panel ADB2GEN         *
  *                      'Generate SQL from DB2 catalog'         *
  *                      issues a message:                       *
  *                                                              *
  *                      ADB1847E A parser error occurred for    *
  *                      the following view.  GEN cannot         *
  *                      complete the request.                   *
  *                      Reason code = 8                         *
  *                      >schema<.>view<                         *
  *                      ADB1873E Processing ended but not       *
  *                      all supplied catrows were used          *
  *                      Reason code = 24.                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When using the GEN function on a view which has multiple
  common table expressions, message ADB1847E / msgadb1847e is
  displayed.  For example, CTE2 common table expression refers
  to CTE1 common table expression.
  
  Example:
  
  CREATE VIEW >view_name< (...) AS
  WITH CTE1 AS(
  SELECT ...
  ),
  CTE2 AS(
  SELECT ..
  
  ),
  ....
  

Problem conclusion

• 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:

  UI18321 UI18322

Modules/Macros

•    ADB2PA
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA20 PSY UI18321

     UP14/05/28 P F405

• RB10 PSY UI18322

     UP14/05/28 P F405

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.