Archives of the TeradataForum

Message Posted: Wed, 04 Jun 2008 @ 11:21:05 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi,

I m running the following MLOAd script:

     .logtable mloadlog;
     .logon DemoTdat/ABC,ABC;

     drop table wt_mytab;
     drop table et_mytab;
     drop table uv_mytab;
     drop table mytab;
     create table mytab (
     f1 varchar(5),
     f2 varchar(5),
     f3 varchar(5)
     )
     ;
     .begin mload tables mytab sessions 4;
     .layout lay1 ;
     .field f1 * varchar(5);
     .field f2 * varchar(5);
     .field f3 * varchar(5);
     .dml label dml1;
     insert foo values (:f1, :f2, :f3);
     .import infile myval.txt
     layout lay1
     FORMAT VARTEXT
     apply dml1;
     .end mload;
     .logoff;

The input file is

     ABC  |XYZ  |wer

but i am getting the error

UTY4017 Not enough data in vartext record number 1.

can anyone help me with this..i feel there is some problem with my input file. Please help.

Regards,

Neha

	<Prev	Next>		<<First	<Prev	Next>	Last>>