Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   UTY4017 Not enough data in vartext record number 1
 
From:   Shukla, Neha

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016