My other requirement is that I need to pad non null numeric value with zeros (prefix the value with adequate no. of zeros).
eg for a numeric column of size (7,2) if my value from source is 10.1 my target should have 00010.10
For this i tried using the "Null String" and "Padding" option of the column definition of a sequential file. but instead of getting a value prefixed by zeros i get it prefixed by spaces.
![Crying or Very sad :cry:](./images/smilies/icon_cry.gif)
So i ended up using routines to manually do that.
Please help. Thanks