I want to select certain items from a table and put these into a csv file. The code below puts them into a txt file but has the heading and comma seperating the fields. Is it possible to send data straight to a csv file, with no headings from a table?
select barcode, Descr from plu to file "temp.txt" where upper(DESCR) like "%" + SEARCHDESC + "%
select barcode, Descr from plu to file "temp.txt" where upper(DESCR) like "%" + SEARCHDESC + "%