Decimal Column in XML file

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
alisoviejo
Participant
Posts: 49
Joined: Fri Nov 11, 2005 10:19 am

Decimal Column in XML file

Post by alisoviejo »

When loading a decimal column values to a sequential file, the results are as expected

000001.50
000002.50
etc

and when the same source data is loaded into an XML file , the 0s are trimed

1.5
2.5

Is there a env variable we can use to avoid this happening, like in oracle we can use preserve_blanks.

Desired xml file values are 000001.50 and 000002.50


Thanks,
ALISO
Post Reply