Equivalent Decimal Datatype

[Raamc]

Hi,

What is the equivalent datatype in Datastage for S9(14).99.
It is a decimal field but i have ambiguity over the length?Is it Decimal[16,2] Or Decimal[15,2].

Thanks in Advance

Thanks
Raam

[ray.wurlod]

9(14) indicates 14 digits to the left of the decimal place, and V99 indicates two digits to the right. Therefore there is a total of 16 significant digits, from which you can deduce that the equivalent data type is Decimal(16,2), because precision is the total number of significant digits.