PM86215: GEN FUNCTION: SQL STMT NOT COMPLETELY PARSED ADB2PA: THE FOLLOWI NG STATEMENT COULD NOT BE PARSED CREATE FUNCTION ADB1932W RC28

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS' GEN function issues a
  message:
  SQL stmt not completely parsed
  
  ADB2PA: The following statement could not be parsed :
  
  CREATE FUNCTION >function_name< ( >col1< >col_type1<, >col2<...
  
  ADB1932W Parser error - the original DDL will be generated for
  the following object. Please verify the DDL.
  Reason code = 28
  >function_name<
  and ends with a return code 4.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use the Generate (GEN) command to   *
  *                 generate a SQL table function which uses     *
  *                 'WITH common-table-expression' in the        *
  *                 RETURN statement.                            *
  ****************************************************************
  * PROBLEM DESCRIPTION: When performing GEN on a SQL table      *
  *                      function which use 'WITH                *
  *                      common-table-expression' in the         *
  *                      RETURN statement, the warning           *
  *                      message  ADB1932W / msgadb1932W is      *
  *                      observed:                               *
  *                                                              *
  *                      SQL stmt not completely parsed          *
  *                                                              *
  *                      ADB2PA: The following statement         *
  *                      could not be parsed :                   *
  *                                                              *
  *                      CREATE FUNCTION >function_name<         *
  *                      ( >col1< >col_type1<, >col2<...)        *
  *                                                              *
  *                      ADB1932W Parser error - the             *
  *                      original DDL will be generated          *
  *                      for the following object. Please        *
  *                      verify the DDL.                         *
  *                                                              *
  *                      Reason code = 28                        *
  *                      >function_name<                         *
  *                                                              *
  *                      and ends with a return code 4.          *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When performing GEN on a SQL table function which use 'WITH
  common-table-expression' in the RETURN statement, the warning
  message  ADB1932W / msgadb1932W is observed.
  

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:

Modules/Macros

• ADB2PA
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK94291

     UP13/05/16 P F305

• RA20 PSY UK94292

     UP13/05/16 P F305

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.