BTEQ Export not showing column name if no rows are returned

Tools & Utilities
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.