Convert decimal value to Integer

, ,
1

Hi Guys,
I have a DB2 Column as integer but i get data as String (OriginallyDecimal value) , i thought there wil be implicit conversion but its giving an error saying cannot insert 1.000 value.so what should i do.

Thanks
Chinna

2

You can do several things. One option would be to use WmPublic/pub.string:numericFormat to transform the value before inserting.

  • Percio