0 - 2 of 2 tags for dif export mode


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?

Hi all,

In my project,there is a requirement to exporting to an Excel using BTEQ.
I used DIF mode to export data.
The data looks fine,but i need the field names of the query also to be populated in the excel,which is not happening.
Some one pls help me out regarding this.