precision allowed in decimal datatype

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
harryhome
Participant
Posts: 112
Joined: Wed Oct 18, 2006 7:10 am

precision allowed in decimal datatype

Post by harryhome »

have source with number datatype with data 18 decimal place after decimal point.

in server we have limit of 15 precision in decimal datatype

same is the case with parallel?
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

That's not a "hard limit", more of a soft one in Server as 15 just happens to be the default value for precision in the configuration file. And "after the decimal point" would be scale not precision.

Have you tried it? Had any problems with it?
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply