I'm using the FTP_Enterprise stage for SFTP for the first time. When my numeric columns are being sent through, the recipient is seeing leading zeros on the numbers. So the column was define Numeric 38 and my data is showing up as
It is likely related to the data type chosen rather than the FTP stage or type of transfer. Replace the FTP stage with Sequential File stage to see. Then do a search on "remove leading zero" which is a topic that has been resolved online here many times over. Resolve it prior to FTP.
Choose a job you love, and you will never have to work a day in your life. - Confucius
That's how DataStage works, and always has. It adds leading and trailing nonsignificant zeroes to the extent specified by the Precision and Scale settings. Don't worry, it's still the same number and will produce the same results in arithmetic.
You can only remove the zeroes if the target data type is string of some kind.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
As Ray has hinted at, but not explicitly stated, convert your numeric value into a string inside DataStage before writing to the CSV file, and your leading zeroes will not appear.