UTY4017 Not enough data in vartext record number 1

Database
gkk
Enthusiast

UTY4017 Not enough data in vartext record number 1

Target Table : xyz

CO_ID VARCHAR(3) CHARACTER SET LATIN NOT CASESPECIFIC,
CLI_ID VARCHAR(11) CHARACTER SET LATIN NOT CASESPECIFIC,

Mload Script :

.LAYOUT L_ins ;

.FIELD CO_ID * VARCHAR(200);
.FIELD CLI_ID * VARCHAR(200);

.DML LABEL INS;

INSERT INTO xyz
(
CO_ID
,CLI_ID
)
VALUES
(
:CO_ID
,:CLI_ID
)

.IMPORT INFILE E:\sdfs\sdfs\file_dsfsdfs.dat
FORMAT VARTEXT '~'
LAYOUT L_INS
APPLY INS;

Error :

====================================================== ==================
= =
= MultiLoad Acquisition Phase =
= =
====================================================== ==================
**** 11:17:57 UTY4017 Not enough data in vartext record number 2.

**** 11:17:57 UTY1803 Import processing statistics
. IMPORT 1 Total thus far
. ========= ==============
Candidate records considered:........ 1....... 1
Apply conditions satisfied:.......... 1....... 1
Candidate records not applied:....... 0....... 0
Candidate records rejected:.......... 0....... 0
====================================================== ==================
= =
= Logoff/Disconnect =
= =
====================================================== ==================
**** xx:xx:xx UTY6215 The restart log table has NOT been dropped.
**** xx:xx:xx UTY6212 A successful disconnect was made from the RDBMS.
**** xx:xx:xx UTY2410 Total processor time used = '0.171875 Seconds'
. Start : xx:xx:xx - WED xxx xx, 2011
. End : xx:xx:xx - WED xxx xx, 2011
. Highest return code encountered = '12'.

Please Help me How to resolve this Problem ?

Tags (1)
1 REPLY

Re: UTY4017 Not enough data in vartext record number 1

Hi,

Check your data source file. I guess, u have defined only one column and in layout section of mload script you have defined two fields. Since you have defined two fields in layout section, mload script is trying to read two column data from data source file in acquisition phase.

Regards,

Mirza