Decimal field with scale zero

[swathi Singamareddygari]

Hi all,

I am facing a problem with the decimal field having scale zero

I am fetching the demial[15,0] field from db2 database using
ODBC stage.

when i am doing this one i got the warning as

"TBL_SRV_REQ_CI: When checking operator: When binding output interface field "PRSN_ID_MEM" to field "PRSN_ID_MEM": Implicit conversion from source type "int64" to result type "decimal[15,0]": Possible range limitation."


can any one know please help me

Thanks for your help

Regards

Swathi s

[chulett]

An exact search for Implicit conversion from source type "int64" found 18 other posts on this subject, see if any of them help.

[dsuser_cai]

try to change the data type to double (leave the length empty), check the edit column meta data