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.
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.