Hi,We tried to load data in UTF-8 format with tab as delimiter using Mload. But it is moving to ET tables and the errorcode is '6705'.here is the sample UTF8 data(with tab delimiter):63 ÌÊ33 Ä/23 ÂÛMload:.LOGTABLE testlgg;.logon xxxxxxxxxxxx.BEGIN IMPORT MLOAD TABLES cust_gr_utf;.LAYOUT nw; .FIELD in_dt1 1 varchar(4); .FIELD in_dt2 * varchar(100);.DML LABEL LABELA;INSERT into cust_gr_utf( cust_no, cust_name)values(:in_dt1, :in_dt2 );.IMPORT INFILE test.utf8 FORMAT VARTEXT '09'XC LAYOUT nw APPLY LABELA;.END MLOAD;.LOGOFF;thanks in advance,
Hi,
We tried to load data in UTF-8 format with tab as delimiter using Mload. But it is moving to ET tables and the errorcode is '6705'.
here is the sample UTF8 data(with tab delimiter):
63 ÌÊ
33 Ä/
23 ÂÛ
Mload:
.LOGTABLE testlgg;
.logon xxxxxxxxxxxx
.BEGIN IMPORT MLOAD
TABLES cust_gr_utf;
.LAYOUT nw;
.FIELD in_dt1 1 varchar(4);
.FIELD in_dt2 * varchar(100);
.DML LABEL LABELA;
INSERT into cust_gr_utf(
cust_no,
cust_name)
values(:in_dt1,
:in_dt2
);
.IMPORT INFILE test.utf8
FORMAT VARTEXT '09'XC
LAYOUT nw
APPLY LABELA;
.END MLOAD;
.LOGOFF;
thanks in advance,