topic db2 and datatypes problem in All Apps and Add-ons

db2 and datatypes problem

AKalika1981 — Thu, 30 Jan 2014 23:24:58 GMT

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.

Re: db2 and datatypes problem

dwaddle — Mon, 03 Feb 2014 05:10:26 GMT

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.doc%2Fsrc%2Ftpc%2Fimjcc_cjv00003.html

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.

Re: db2 and datatypes problem

AKalika1981 — Mon, 03 Feb 2014 19:02:17 GMT

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.