How do I create an export file similar to the one that SQL Assistant export does. In sql assistant I can specify a field enclose character and a field separator. I can do that in bteq (field separator) but can't find how to do a field enclosure.
I've tried data file but I end up getting weird wing ding like characters in it. I've tried reprot file but I get a bunch of blank lines between the rows and the titles.
here is my script: