Page 1 of 1

The source decimal has even precision, but non-zero error

Posted: Fri Aug 03, 2012 10:41 am
by ravipuli
Hi,

Hi Experts,

Source column is datatype is decimal(30,10) and o/p column datatype is decimal(30,1). When i run the iob iam geting below errors pls help me to solve

'APT_Decimal::ErrorBase: From: the source decimal has even precision, but non-zero in the leading nybble, or is too large for the destination decimal..' from input dataset '0' is NULL. Record dropped.

Posted: Fri Aug 03, 2012 10:43 am
by ravipuli
sory t/g datatype is 30,10

Posted: Fri Aug 03, 2012 4:18 pm
by ray.wurlod
Read Chapter 2 of Parallel Job Developer's Guide to learn how Decimal (and other) data types are stored. This should answer your question.

Posted: Thu Oct 18, 2012 9:30 am
by Jag
ray.wurlod wrote:Read Chapter 2 of Parallel Job Developer's Guide to learn how Decimal (and other) data types are stored. This should answer your question.
Why couldn't you just answer the question? Now I googled this same issue, and your answer doesn't help me. So thanks for nothing. You are useless and unhelpful and you shouldn't respond so rudely when people just want help.

Posted: Thu Oct 18, 2012 9:56 am
by MarkB
This topic was from August ... perhaps you might want to start your OWN thread, explain in detail what you are doing, the error you are getting, etc.

Just googling the error message gives quite a few pointers - what have you tried, and what have you found? That might be a better way to get some assistance than yelling at Ray :twisted:

Posted: Thu Oct 18, 2012 2:00 pm
by ray.wurlod
I prefer to teach people to fish rather than to give them a fish, the benefit of the latter being ephemeral.