How to find the length for decimal field

[somu_june]

Hi "chulett",


Iam pasting you some data samples for Price field here

Price
1195999900000.00 (15,2)
15600000000.00 (13,2)
12999999000.00 (13,2)
11959999000.00 (13,2)
4056000000.00 (12,2)
3754351000.00 (12,2)
3588000000.00 (12,2)


And ray I could not find your Isvalid() server function in the server forms

Thanks,
SomaRaju

[chulett]

Hi "soma_june",

You can find it here, two posts up from the last post.

[mjmtabor]

I'm new to datastage but why don't you interpret the value by seeing if it is less than 1000000000000.00. Instead of looking at length look at it from a value standpoint