BTEQ Export not showing column name if no rows are returned

Tools
Enthusiast

BTEQ Export not showing column name if no rows are returned

 

My BTEQ Export is working fine.

However, when there is no rows to return , it is not even returning COLUMN NAMEs. Hence a blank file is generated.

I want to have COLUMN NAMES atleast in my output file even if no rows are present.

I am using BTEQ Export.

I don't want to hardcode the columnnames. Is there an option available for atleast exporting COLUMN NAMEs even if rows are not returned.

I am using below options as per my requirement:

.set width 5000

.Set echoreq off

.Set Titledashes off

.Set Separator '~'

.Set Format off

 

Thanks in advance.