I'm developing an application based on data from an ERP. This ERP uses the INFORMIX database whose file export pattern is DELETED BY PIPES AND WITHOUT TEXT QUALIFICATION.
I need to import the data from Informix to MySQL, but must have all fields delimited by double quotation marks separated by commas.
To import into INFORMIX I know how to set the delimiters
LOAD FROM report/novoplan.csv DELIMITER ";" INSERT INTO ctplano
But I have no idea how to define the desired structure in the output file