How to write BTEQ output to a CSV file?

Write the SQL query as
SELECT COL1||','||COL2||','||COL3||','||.....||','||COLN FROM TABLE_NAME;


OR


. SET FORMAT ON;
.set separator ',';

Command before the SQL command in your BTEQ EXPORT script