when doing an export to a file of del and using a select * from a table I am finding that all the records have exported but some of the fields have no data. The fields are defined as VARCHAR. I tried to export as filetype ixf and wsf but could not read these properly. Any ideas ?
I am sorry to ask but do the fields contain data. If the fields contain varchar data then they are exported with the data in ' ' single quotes and if you feel that select * does not work then try selecting the columns explicitly, though I see no reason why it should not work. Export to a csv format and open the csv with excel. This would satisfy your doubt.
Please note that the IXF file is native to DB2 and hence you will never be able to read the contents of the exported file.
The WSF file is for work sheet format and relates to Lotus however the same can be opened in excel.