FTP Leading Zeros

MrBlack · Post by **MrBlack** » Fri Sep 04, 2015 11:17 am

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

Code: Select all

00000000000000000000000000000000054321

How would I remove these leading zeros from the CVS so my recipient doesn't have to?

qt_ky · Post by **qt_ky** » Fri Sep 04, 2015 6:33 pm

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.

ray.wurlod · Post by **ray.wurlod** » Fri Sep 04, 2015 11:20 pm

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.

ArndW · Post by **ArndW** » Mon Sep 07, 2015 2:59 am

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.

arunkumarmm · Post by **arunkumarmm** » Thu Oct 15, 2015 2:48 am

Anyway its a csv file. Why cant you define your metadata as varchar? Thats should solve your problem I guess.

naveenkumar.ssn · Post by **naveenkumar.ssn** » Fri Oct 16, 2015 1:58 am

hi

Cant we add a transformer and trim the leading "zeros".

Regards
Naveen

ray.wurlod · Post by **ray.wurlod** » Sun Oct 18, 2015 4:03 pm

Not if the data type is Decimal.

Well... you can, but DataStage will reinstate them.

DSXchange

FTP Leading Zeros

FTP Leading Zeros

Re: FTP Leading Zeros