length of decimal data type

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
sweety123
Participant
Posts: 18
Joined: Thu Dec 10, 2009 5:28 am

length of decimal data type

Post by sweety123 »

Hi,

I know this is a very basic question about DataStage. What I want to know is when we define a field as Decimal(m,n) in DataStage, how many characters (digits and decimal sign) would the field hold?

If I have to read this field as varchar or char what should be the size of it?
Top
priyadarshikunal
Premium Member
Premium Member
Posts: 1735
Joined: Thu Mar 01, 2007 5:44 am
Location: Troy, MI

Post by priyadarshikunal »

m+2
Priyadarshi Kunal

Genius may have its limitations, but stupidity is not thus handicapped. :wink:
Top
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Contact ray.wurlod

Post by ray.wurlod »

At least (m+2).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Top
Post Reply

Return to “General”