Write the SQL query as
SELECT COL1||','||COL2||','||COL3||','||.....||','||COLN FROM TABLE_NAME;
OR
. SET FORMAT ON;
.set separator ',';
SELECT COL1||','||COL2||','||COL3||','||.....||','||COLN FROM TABLE_NAME;
OR
. SET FORMAT ON;
.set separator ',';
Command before the SQL command in your BTEQ EXPORT script
No comments:
Post a Comment