PH33332: GEN DDL STORED PROCEDURE PARSE ERROR ASC DESC KEYWORD XMLAGG ADB7955E ADB2PA ADB1932W REASON CODE = 28

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• GEN/DDL of a stored procedure containing the ASC or DESC keyword
  in an XMLAGG function may encounter a parse error:
  
  ADB7955E ADB2PA Unexpected token after >sort-key<
  keyword - expected keyword ")"
  
  ADB7955E ADB2PA ADB2PA: The following statement could not be
  parsed :
  
  [text of stored procedure follows]
  
  ADB1932W Parser error - the original DDL will be generated for
  the following object. Please verify the DDL.
              Reason code = 28
              >stored-procedure name<
  
  
  Keywords:  msgadb7955e; msgadb1932w
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the Db2 Administration Tool for     *
  *                 z/OS                                         *
  ****************************************************************
  * PROBLEM DESCRIPTION: Processing DDL with an XMLAGG function  *
  *                      in a stored procedure might result in   *
  *                      parser error ADB7955E.                  *
  ****************************************************************
  Extracting DDL for a stored procedure that contains the ASC or
  DESC keyword in an XMLAGG function might result in the following
  error:
  
  ADB7955E ADB2PA Unexpected token after >sort-key< keyword -
  expected keyword ")"
  ADB7955E ADB2PA ADB2PA: The following statement could not be
  parsed : >stored_procedure_ddl<
  

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:

  UI75376

Modules/Macros

• ADB2PA
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI75376

     UP21/06/02 P F105

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.