LOAD
Dear recipient:
I execute a next command:
load from "/usr2/informix/serme/energias/energias.csv" DELIMITER ","
insert into energias;
The file energias.csv is resulted of export a table in db2:
"TUL01",20,40
"MAM01",10,30
........
My table energias have a next structure:
nombre char(6);
valor1 integer;
valor2 integer;
When I to execute a LOAD and to make query languaje select * from
energias with dbaccess, the field nombre to load "TUL01 , "MAM01. Take
a " ( double quotes) like character.
I need to load this field without double quotes.
e.g
TUL01
MAM01
Can you help me please?
Thanks for your atentions.