topic Re: JAVA equivalent data type to NUMERIC in idb2 in Talend Studio

JAVA equivalent data type to NUMERIC in idb2

rwnetwork — Mon, 09 Dec 2019 23:46:55 GMT

Hi Community,

Does anyone know the java equivalent data type of numeric for idb2 for a tmap component? Screenshot attached.

I have played around with several data types with no success.

Any thoughts?

Thank you

Re: JAVA equivalent data type to NUMERIC in idb2

rmartin2 — Tue, 10 Dec 2019 00:25:14 GMT

Hi,

Any particularity in your job ?

As far as I know it's either decimal or numeric (aliases) in db2.

Re: JAVA equivalent data type to NUMERIC in idb2

rwnetwork — Tue, 10 Dec 2019 14:46:03 GMT

Thanks for responding, it looks like I may have explained my question incorrectly. I'm looking for the Talend equivalent to a NUMERIC data type in idb2.

Thanks for any help!

Re: JAVA equivalent data type to NUMERIC in idb2

Anonymous — Wed, 11 Dec 2019 05:13:25 GMT

Hi,

Could you please try float, double or BigDecimal type based on your data? Since I do not have an environment handy for idb2, I am not able to check it myself.

In worst case, you can read the data as String from database and later do the conversion using a tConvertType component based on your need (But I would ideally prefer to do it from DB component itself and this is just a short cut to proceed).

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved