JAVA equivalent data type to NUMERIC in idb2

[rwnetwork]

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

[rmartin2]

Hi,

Any particularity in your job ?

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

[rwnetwork]

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!

[Anonymous]

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