Loading UTF8 data using Mload

Tools & Utilities
Enthusiast

Loading UTF8 data using Mload

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,