PI49113: ALLOW DECFLOAT DATA IN AN EXPRESSION-BASED INDEX, AS LONG AS THE FINAL RESULT DATA TYPE IS NOT DECFLOAT

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• Allow DECFLOAT data in an expression-based index, as long as the
  final result data type is NOT DECFLOAT.                 (DN1894)
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 11 for z/OS users                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: This APAR allows DECFLOAT data in an    *
  *                      expression-based index, as long as      *
  *                      final result data type is not DECFLOAT. *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  DB2 for z/OS currently disallows DECFLOAT data in an expression
  for an expression-based index.  That is, a DECFLOAT value
  cannot be referenced in such an expression, an intermediate
  data type cannot be DECFLOAT and the final result data type
  for the expression must not be DECFLOAT.
  
  
  This APAR partially lifts this restriction so that an
  intermediate DECFLOAT value is now allowed in a CREATE INDEX
  statement, as long as the final result data type for the
  expression is not DECFLOAT.
  
  EXAMPLE
  =======
  
  CREATE TABLE MYTABLE1(DECFLOAT_COL DECFLOAT);
  
  CREATE INDEX MYINX1 ON MYTABLE1(DECIMAL (DECFLOAT_COL, 31,3));
  
  The DECFLOAT column, DECFLOAT_COL, is cast as DECIMAL, so the
  resulting key value is a decimal value.
  
  However, DB2 still issues an SQLCODE -350 if the final result
  data type for the expression is DECFLOAT.
  

Problem conclusion

Temporary fix

Comments

• This APAR allows DECFLOAT data in an expression-based index,
  as long as the final result data type is not DECFLOAT.
  
  Additonal Keywords:  SQLDECFLOAT SQLINDEXONEXP SQLCODE350
  

APAR Information

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

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

  UI32257

Modules/Macros

• DSNXIIKY DSNXISB6 DSNXOIDX DSNXOOS1
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RB10 PSY UI32257

     UP15/11/06 P F511

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.