Db2

I've defined a result field as D7.2. When my output is PDF or Excel, data is perfect. If I change the output to a DB2 file, the field comes in as 16.15 and the decimal position is moved. Example: correct amount is .90, when generating a DB2 file the data is 9.000000000000001E-001. I'm only changing the output destination, nothing else in the query.

Hi,

We have done some testing and have been able to recreate this situation. The field type in the generated DB2 file is float double, even though the result field is defined as a packed decimal.

Please open a Salesforce case at https://www.ibm.com/mysupport/ and we'll look closer.