BTEQ: How to remove column header from the BTEQ output while exporting the output to flat file

Option 1:

.SET RECORDMODE OFF;

.EXPORT DATA FILE = ...;

Option 2:

Add (title '') to each column within your select list.

Example:

select

col1 || '|' || col2 || ',' || ... (TITLE '')

from tab;