PH17958: ABEND S0CA IF WHERE CLAUSE WITH PREDICATE ON DECIMAL DATA

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• During a logical unload run in native mode an ABENDS0CA occurs
  if the specified SELECT statement has a WHERE clause with a
  predicate requiring the comparison of a DECIMAL(n,p) type
  expression and a constant greater than the maximum value of the
  DECIMAL(n,p) data type. Such a comparision is needed for the
  evaluation of predicate involving the following operators : =,
  <, >, IN and NOT IN.
  

Local fix

• If applicable, consider running the unload in SQL mode by
  specifying the DB2 FORCE option.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 High Performance Unload         *
  *                 for z/OS                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: During a logical unload run in native   *
  *                      mode an ABENDS0CA occurs if the         *
  *                      specified SELECT statement has a WHERE  *
  *                      clause with a predicate requiring the   *
  *                      comparison of a DECIMAL(n,p) type       *
  *                      expression and a constant greater than  *
  *                      the maximum value of the DECIMAL(n,p)   *
  *                      data type. Such a comparision is needed *
  *                      for the evaluation of predicate         *
  *                      involving the following operators : =,  *
  *                      <, >, IN and NOT IN.                    *
  *                      WORKAROUND FIX:                         *
  *                      If applicable, consider running the     *
  *                      unload in SQL mode by specifying the    *
  *                      DB2 FORCE option.                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Code has been changed to fix this problem.
  

Problem conclusion

• Apply the PTF.
  

Temporary fix

Comments

• ×**** PE21/04/15 FIX IN ERROR. SEE APAR PH36327  FOR DESCRIPTION
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UI67514

Modules/Macros

•    INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R430 PSY UI67514

     UP20/01/29 P F001

• R510 PSY UI67516

     UP20/02/04 P F002

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.