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;

Comments