I would like the syntax to unload a file with 3 fields into a .csv file that when viewed in a excel spreadsheet appear as 3 separate blocks/fields rather than one string?
I have tried
select company,id,barcode from documents where filed = 'Y'
appears as 3 seperate colums in unix but 1 field in excel
what you have shown here is just a part of an SQL query, as I have no experience on informix, you will have to show us what it generated in the output file to understand and help you
When you say 1 field in excel, how did you open it?
what doest it look like - one field with 3 data , comma separated?
Not an Informix expert and there may well be options to define the output format in Informix, there are in many other DB query languges, however you can force the output into csv format as follows
select ||'"'||company||'","'||id||'","'||barcode||'"' as csv_record from documents where filed = 'Y'