DSXchange

In the schema file defined for the sequential file (input/output) define the decimal column like - USD_TA: not_nullable decimal[26,3] {null_field='00000000000000000000000000'}; My intention is to take the output to a variable-length format. This way i'll be writing fixed length. If i have a NULL va...

Eventhough you posted it in server forum, i think its related to PX. Datastage pads non significant zeros to decimal and hence the behaviour you saw in datastage management utility. If the values are correct there is no problem at all. If you are loading it to database decimal field, there is no pr...