Decfloat datatype not supported in BODI / BODS

Recently I was working with a few DB2 UDB 9.5 tables and discovered that decfloat datatype columns were not recognized even though I had checked the option to recognize unsupported datatypes as varchar.

I mailed someone who interacts closely with the product group in SAP – Business Objects.

As of today, BOBJ PG says, DECFLOAT datatypes are not supported by both BO Data Integrator and BO Data Services. They have taken it as an enhancement request. Probably will not be as high a priority to see them in the next release itself.

Until then, avoid DECFLOAT datatypes in DB2.