the value applied to a Teradata 8 byte decimal was out of range -- 9.223372036854775808E18

Database

the value applied to a Teradata 8 byte decimal was out of range -- 9.223372036854775808E18

I am trying to load the following data into a field with decimal(20,20) and I get this error msg:

"the value applied to a Teradat 8 byte decimal was out of range"... the data I am loading is 9.223372036853775808E18.

Does anyone know how I can fix this issue?

Thanks in advance!!

2 REPLIES
Enthusiast

Re: the value applied to a Teradata 8 byte decimal was out of range -- 9.223372036854775808E18

Cast the value to decimal(20,20) and then load

Enthusiast

Re: the value applied to a Teradata 8 byte decimal was out of range -- 9.223372036854775808E18

Are you trying to load only the decimal precision? Please double check the definition - its (20,20) & you have a digit '9' before the decimal pt.