DB2 FOR LUW / DB2FORLUW / 970 - DB2

Lack function mapping for SYSIBM.DECIMAL,SYSIBM.DECFLOAT for Z
results in no predicate pushed down to the datasoruce.

Example Federated Query:

select myDecimalCol from myTable where myDecimalCol=

This results in a select of entire table from the datasource
instead.

select myDecimalCol from mytable

****************************************************************
* USERS AFFECTED:                                              *
* All 11.1 Aix users.                                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* N/A                                                          *
****************************************************************

Workaround is to tyepcast the column in the query.

select myDecimalCol from myTable where
myDecimalCol=decimal('')

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

20.09.2016
02.06.2017
02.06.2017