Decimal Column in XML file
Posted: Mon Mar 20, 2006 9:33 am
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,
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,