Detail Filter Issues - DECFLOAT

[rocket21]

I've tried a bunch of tests/work arounds without luck, so hopefully some folks who are much brighter than me can figure out what I'm doing wrong!

I have a DB2 set up with Cognos 10.2, pushing DB2 views through Framework Manager into Cognos.  No issues with all but one.

I have stripped the view in question down to two varchar fields.  If I drop the fields in a list box in Report studio, I can run the report and/or view tabular data.

If I attempt to put a Detail filter on either field with [FIELD_NAME] = ?FIELD_NAME?, I get a XQE-DAT-0001 Data source adatpor error...Invalid character found in a character string argument of the function "DECFLOAT" SQLCODE = -420, SQLSTATE=22018 error when attempting to run the report or view tabular data.

The data is text - occasion & , . and numbers, but nothing bizarre.  I'm able to filter on the same data via another object/view/table without issues.

I can also export the DB2 view data via Datastudio without any issue.  The export is clean when viewed in Notepad.

Any thoughts?   Thank you in advance for your help!

[rocket21]

Resolved:

Downstream there was a left outer join that resulted in some nulls in an integer field.  Even though the integer field wasn't being queried upstream into Cognos, it was still throwing that error.

I ended up splitting the left outer joins, with the second one looking for null values in the right table, and populating those with 0, then union-ing them together.