PK82130: INZU238E UNEXPECTED UNSUPPORTED SELECT.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• INZU238E UNEXPECTED UNSUPPORTED SELECT
  UTILITY CANNOT SWITCH TO SQL PROCESSING
           REASON 0Xc001c / 0X2d7fc2b8
  INZU366I UTILITY RETURN CODE 8 (REASON CODE 0x121a010)
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1. Error message                        *
  *                      INZU238E UNEXPECTED UNSUPPORTED SELECT  *
  *                               UTILITY CANNOT SWITCH TO SQL   *
  *                               PROCESSING                     *
  *                               REASON 0Xxxxxx / 0Xyyyyyyyy    *
  *                      can occur when one of the following     *
  *                      scalar function is used on date/time    *
  *                      data, or on a date/time duration in a   *
  *                      WHERE clause:                           *
  *                          * DAY_OF_MONTH                      *
  *                          * YEAR                              *
  *                          * MIDNIGHT_SECONDS                  *
  *                          * MONTH                             *
  *                          * DAY                               *
  *                          * HOUR                              *
  *                          * MINUTE                            *
  *                          * SECOND                            *
  *                          * MICROSECOND                       *
  *                      Other symptom: When a scalar function   *
  *                      of the previous list is used in the     *
  *                      list of selected items, the type of     *
  *                      the corresponding output field is       *
  *                      incorrectly set to DECIMAL while it     *
  *                      is supposed to be an INTEGER.           *
  *                      PB 9857                                 *
  *                      2. A null indicator is not generated    *
  *                      in the output data for the following    *
  *                      expression, while it should be          *
  *                      generated (expression_1 is a date/time  *
  *                      expression that can not be null,        *
  *                      expression2 is labeled duration         *
  *                      expression that be null)                *
  *                      expression_1 +/- expression_2.          *
  *                      An example of such an expression is:    *
  *                      coldate - colinteger DAY with coldate   *
  *                      that doesn't allow the null and         *
  *                      colinteger that accepts null values.    *
  *                      PB 9888                                 *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  1. Module inznode, function inznodeCheckOperateur and
  inznodeCheckExpression were changed to process the date/time
  values or date/time durations in INTEGER instead of DECIMAL.
  2. Module inznode, function inznodeCheckOperateur was changed
  to add a nullable flag for the described case.
  

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

•    INZQRYV8
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R310 PSY UK45123

     UP09/03/26 P F903

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.