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

ravipuli · Post by **ravipuli** » Fri Aug 03, 2012 10:41 am

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.

ravipuli · Post by **ravipuli** » Fri Aug 03, 2012 10:43 am

sory t/g datatype is 30,10

ray.wurlod · Post by **ray.wurlod** » Fri Aug 03, 2012 4:18 pm

Read Chapter 2 of Parallel Job Developer's Guide to learn how Decimal (and other) data types are stored. This should answer your question.

Jag · Post by **Jag** » Thu Oct 18, 2012 9:30 am

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.

MarkB · Post by **MarkB** » Thu Oct 18, 2012 9:56 am

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

ray.wurlod · Post by **ray.wurlod** » Thu Oct 18, 2012 2:00 pm

I prefer to teach people to fish rather than to give them a fish, the benefit of the latter being ephemeral.