I am new for bteq script. I tring to export data from table to text file. While using below script i am facing space issue between columns. Please refer the below screenshot. Due to this issue i am not able to download data from table which is having more than 5 lack. Because the files size are increasing more 5 GB. Can any one help how to solve this issue.
.EXPORT FILE =file1.txt;
.SET SEPARATOR '|';
.SET WIDTH 32767;
sel * from sample_table;
You currently export your data in REPORT format, which results in fixed width data.
If you want pipe-delimited readable data you can do: