Hi,
Is there an option in export command to fetch the column names used in the query as well as the data returned by the query.

Also,Ne other way to achieve this is also welcome.

Input Query
select col1,col2 from table

Output I want is
col1,col2
a,b
c,d
e,f



Any Help appreciated


Thanks
Ashutosh

How about this?
EXPORT TO filename OF DEL ... VALUES ('col1' , 'col2') UNION ALL SELECT col1 , col2 FROM table

What if col1 and col2 are defined as int?

I think the column names in "EXPORT TO filename OF DEL ... VALUES ('col1' , 'col2')" would have to be changed to numbers if the columns are defined as int.

Or you cast the results of the SELECT to CHAR:
Of course, this will most probably result in rounding differences on floating point values.