Truncation of Leading Zeros in BTEQ Export

Database

Truncation of Leading Zeros in BTEQ Export

Hi,

When using Teradata BTEQ export to load a CSV file my leading zeros are getting truncated. Even if I cast the column to be Char(4) my leading zeros are still getting truncated. Please someone help out on this.

Thanks!

2 REPLIES
Teradata Employee

Re: Truncation of Leading Zeros in BTEQ Export

CAST the column to apply a FORMAT that includes leading zeros, if that's what you want in your output.

Re: Truncation of Leading Zeros in BTEQ Export

Hi Fred, Thanks for your help! For some reason when I export the records to a csv file, the leading zeros are not appearing. I tried to format as well, but even with which its not working. But when we export the records to a xls format the zeros do appear. Please let me know if anything else can be done.

Thanks!