decimal value in datastage transformer

[nimcurry]

I have a column of decimal (5,5). I want to put default value as "+000.00000". I tried with several options such in meta data such as setting precision=5 or using the option "Packed to no(separate)", setting sign position=leading, but all I am getting value as "+000000". How can I correct this?

[FranklinE]

From your description, your column has the wrong length setting. The attributes are total length,decimal length. In your post, you have a 5-position number with five positions to the right of the decimal.

[chulett]

Yup, it would need to be decimal(8,5) to get the output you are looking for.

[nimcurry]

Thanks it worked. However in order to get a "+" if I use the option packed=no(separate) and sign position=leading I get the value as "+00000000". is there anyway I can get the whole "+000.00000) within decimal?