Exporting and Column names 1

[1974maiden]

Hi,

Does anyone know how to include column names when exporting to a file .....

EG
EXPORT TO "C:\NOW.XLS" OF WSF MODIFIED BY 1 METHOD N (WO_DOCUMENT_NUMBER_ID) MESSAGES "X"
SELECT WO_DOCUMENT_NUMBER_ID FROM E6DW_DATA.PBVIEWS_SNAP_WORK_ORDERS ;

or

EXPORT TO "c:\now.csv" of del MESSAGES "X"
select WO_DOCUMENT_NUMBER_ID
from PBVIEWS_SNAP_WORK_ORDERS;

Both the above don't include the column names ...

Thanks

 

[gregsimpson]

Jimmy,

not had time to try it, however the documentation I have in front of me says that if you specify the file as either WSF or IXF and omit the METHOD paramter, the column names in the table will be used.

Cheers
Greg

 

[1974maiden]

Thanks Greg .... but it didn't seem to work !!

 

[juliane26]

well, it works in WSF format, but then you would have an extra step to convert to ascii ...


Juliane

 

[1974maiden]

Juliane26,

Could you paste the code please .....

 

[juliane26]

almost the same:

EXPORT TO "c:\now.wsf" of wsf MESSAGES "X"
select WO_DOCUMENT_NUMBER_ID
from PBVIEWS_SNAP_WORK_ORDERS;

when opening with excel or lotus123 the col names are there.

unfortunately, that is no ascii. I have not found an option in the documentation how to achieve it.




Juliane