1
I’m developing an application based on the data of an ERP. This ERP uses the INFORMIX database whose file export standard is BOUNDED BY PIPES AND WITHOUT TEXT RATING.
I need to import Informix data into Mysql, but you need to have all fields delimited by double quotes and separated by semicolons.
To import to INFORMIX I know how to define delimiters
LOAD FROM report/novoplan.csv DELIMITER ";" INSERT INTO ctplano
But I have no idea how to set the desired structure in the output file