PM08077: HPU DOES NOT ACCEPT A WHERE CLAUSE THAT CONTAINS QUANTIFIED PREDICATES.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• HPU does not accept a WHERE clause that contains quantified
  predicates like "= ANY (subselect)" or "<> ALL (subselect)", and
  issues error messages:
  INZU010I ITEM STARTING AT (11,5) ENDING AT (11,8)
  INZU016E EXPRESSION STATEMENT SYNTAX IS INVALID
  This occurs for each word found in the subselect.
  PB 10527
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1. When using an UNLOAD from an Image   *
  *                      copy (using COPYDDN) that contains more *
  *                      than one table, with ORIGINOBID 0, HPU  *
  *                      unloads data from all the tables        *
  *                      instead of unloading only the first one *
  *                      found in the FIC. This can also give    *
  *                      any kind of error, because processing   *
  *                      data that does not corresond to the     *
  *                      table structure (for example abend      *
  *                      S0C1, S0C7, S0C4, or conversion error   *
  *                      messages or error messages) specifying  *
  *                      FIELD OVERLAP END OF RECORD.            *
  *                      PB10073                                 *
  *                      2. HPU does not accept WHERE clause     *
  *                      that contains quantified predicates     *
  *                      like "= ANY (subselect)" or "<> ALL     *
  *                      (subselect)", and issues error          *
  *                      messages                                *
  *                      INZU010I ITEM STARTING AT (11,5)        *
  *                       ENDING AT (11,8)                       *
  *                      INZU016E EXPRESSION STATEMENT SYNTAX    *
  *                       IS INVALID                             *
  *                      for each word found in the subselect.   *
  *                      The expected result is to process the   *
  *                      SELECT using SQL (as the subselects     *
  *                      are not natively supported by HPU).     *
  *                      PB 10527                                *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  1. Module UDBCRRTS was changed to select only from the first
  table found in the image copy when ORIGINOBID 0  is used.
  2. Module inzdyacc was changed to avoid errors in case of non
  supported select that contain quantified predicates or row
  value expressions.
  

Problem conclusion

• APPLY the PTF.
  

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

•    INZRSAVE
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R310 PSY UK56337

     UP10/04/29 P F004

• R320 PSY UK56338

     UP10/04/29 P F004

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.