Exporting informix data

2

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

    
asked by anonymous 14.09.2017 / 16:03

0 answers