I was using the following function to export data

MemoExecDQL(DQLMemoField,"Data-Entry Field1","Data-Entry Field2","Data-Entry Field3","Data-Entry Field3","Export File")

But, header came in just like what is in the list records.

For an example, firstc(Zip,5) in the list records, produced the same in the header.

Is there any option to customize the header or even turn it off ?

MemoExecDQL come with full formatting of body etc like DFD.
So the only thing you need to include is a format Memo.

MemoExecDQL(DQLMemoField,"Data-Entry Field1","Data-Entry Field2","Data-Entry Field3","Data-Entry Field3","Export File",DQLMemoFormat)

in DQLMemoFormat.

.items

[{CustomerNr}]~[{CustomerName}]~etc.

.end

if you want named headers just write them in.

DE9

In DE9 we introduce AS as a new pragma in DQL so you will be able to do.

List records
firstc(MyField,4) as "CustomerNr" ;
concat("My NAme is:" , namefield) as "MyName" ;

MemoExecDQL(DQLMemoField,"Data-Entry Field1","Data-Entry Field2","Data-Entry Field3","Data-Entry Field3","Export File",DQLMemoFormat)

Is this available in 8.5 ?

Yes, defiinitly. Have been for quite some time too.