PH01307: DB2 ADMIN TOOL - DDL/GEN COMMAND ABEND FOR STORED PROCEDURE KEYWORD "UNNEST" PARSER ERROR ADB2PA COLLECTION-DERIVED-TABLE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• GEN/DDL of a stored procedure with a collection-derived-table
  may fail with the following:
  Unexpected token after IN_ABC keyword - expected keyword
          '(' after UNNEST (..) .. <correlation- name>
  ADB2PA: The following statement could not be parsed
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool         *
  *                 for z/OS who use the DDL or GEN              *
  *                 command.                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: When running a DDL or GEN               *
  *                      command on a stored procedure           *
  *                      with a collection-derived-table,        *
  *                      the parser may issue an error           *
  *                      message.                                *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When running the DDL GEN command on a stored
  procedure with a collection-derived-table (that is,
  containing the UNNEST function), the parser may issue
  the following error message:
  
   Unexpected token after IN_ABC keyword - expected
   keyword '(' after UNNEST (..) .. >correlation- name<)
  
   ADB2PA: The following statement could not be parsed
  

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

• RB20 PSY UI58928

     UP18/10/12 P F810

• RC10 PSY UI58929

     UP18/10/12 P F810

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.