BTEQ .EXPORT DIF Column HEADER ISSUE

Tools & Utilities

BTEQ .EXPORT DIF Column HEADER ISSUE

Hi,

I am trying to export SQL output to excel file using .export DIF. I am getting SQL output but coulumn header is getting supressed. REPORT option outputs column header but output in excel is in a single row so not desirable. 

Anyone has idea on how to output column header using .export DIF?

I tried including 2 SQLs .. separate for column headers but it is not showing me output from second SQL

example

.export DIF file = a.csv

sel "colname1" as col1, "colname2" as col2 .. ;

.export reset

.export DIF file = a.csv

sel ...  .. (This is actual data SQL)

.export reset

In excel file I can see header but no data from second SQL. Am I missing something here?