Decimal operator error

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
ketanshah123
Participant
Posts: 88
Joined: Wed Apr 05, 2006 1:04 am

Decimal operator error

Post by ketanshah123 »

Hi

I am facing following error

APT_Decimal::operator=: the source decimal has even precision, but non-zero in the leading nybble, or is too large for the destination decimal.


source destination field are of length 5 with scale 2 and destination are files where field are of length 7 and scale and 1 file has field of length 5 with scale 2

for one field I am doing some calculation and its going in destination field

let me know how can I resolve this issue ?

Thanx in advance
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

First question - did you search for your message? An exact search here for "the source decimal has even precision, but non-zero in the leading nybble" turned up 14 matches, several of which were marked as resolved.
-craig

"You can never have too many knives" -- Logan Nine Fingers
abc123
Premium Member
Premium Member
Posts: 605
Joined: Fri Aug 25, 2006 8:24 am

Post by abc123 »

Also, please try to re-state your question. Do you have one or more fields in the source file which are Decimal(5,2) and going to Decimal(7,1)?

Please make it clear.
Post Reply