db2 and datatypes problem

[AKalika1981]

Hi -
I am trying to connect to db2 through the db connect app. I can connect to the database and also see all the tables. I can see all the data as well unless it's decfloat data type - then it just shows up blank.
Has anyone encountered the same issue? Can Splunk understand all of db2 datatypes?

So I have no issues connecting to the database or seeing the data - UNLESS that data is data type defloat - and then I see blank spaces where numbers should be.

[dwaddle · Accepted solution]

I have not tried to use the DECFLOAT type with DBX, but it seems that DB2 maps that data type to a BigDecimal object. See http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/index.jsp?topic=%2Fcom.ibm.db2.luw.apdv.java.do...

It is possible that DB Connect does not know how to deal with the DECFLOAT type. You could try altering your SQL to cast it to a DECIMAL.

And if you have enterprise support you should file a support case.

[AKalika1981]

Thanks! After playing with it for a bit casting DECFLOAT to another datatype in SQL in dbx has proven to be the best solution for us.