# PM86502: ABEND 04E AT DSNXRFC P106

## Subscribe

You can track all active APARs for this component.

## Error description

• ```predicate :WHERE GOL1 >='013021100000023001'
COL1 is defined as double
```

## Local fix

• ```N/A
```

## Problem summary

• ```****************************************************************
* USERS AFFECTED: All DB2 10 for z/OS users of predicates with *
*                 a double floating point column being         *
*                 compared to a decimal floating point         *
*                 constant.                                    *
****************************************************************
* PROBLEM DESCRIPTION: An ABEND04E RC00E70005 can occur at     *
*                      location DSNXGRDS DSNXRFC P106 for an   *
*                      SQL statement containing a predicate    *
*                      that compares a double floating point   *
*                      column to a decimal floating point      *
*                      constant.                               *
****************************************************************
* RECOMMENDATION:                                              *
****************************************************************
An ABEND04E RC00E70005 can occur at location DSNXRFC offset P106
for a query that contains a predicate which compares a double
floating point column to a constant that is a decimal floating
point number.  The problem can occur when precision is lost when
converting the constant to a DOUBLE data type.

The following example illustrates how this problem can occur.

1. Create a table with a column defined as a DOUBLE data type.

CREATE TABLE TEST (C1 DOUBLE);
INSERT INTO TEST VALUES (1.11111111111111);

2. Execute the following query.

SELECT * FROM TEST
WHERE C1 >= DECFLOAT('013021100000023001')

DB2 should retrieve the inserted data when executing the query.
However, the above ABEND occurs because DB2 did not handle
converting the decfloat constant correctly.
```

## Problem conclusion

• ```DB2 has been modified to convert the decfloat constant correctly
to a double floating point number which will allow the predicate
comparison to work properly.

Additional Keywords : SQLDECFLOAT SQLDOUBLE SQLDECIMAL SQLFLOAT
```

## APAR Information

PM86502

• ### Reported component name

DB2 OS/390 & Z/

5740XYR00

A10

CLOSED PER

NoPE

NoHIPER

NoSpecatt

2013-04-08

2013-06-19

2013-08-02

UK95255

## Modules/Macros

• ```   DSNXRFC
```

## Fix information

• ### Fixed component name

DB2 OS/390 & Z/

5740XYR00

## Applicable component levels

• ### RA10 PSY UK95255

UP13/07/09 P F307

## Fix is available

### Document information

More support for: DB2 for z/OS

Software version: A10

Reference #: PM86502

Modified date: 02 August 2013