Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>  
Next> Last>>  

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


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
     apply dml1;
     .end mload;

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.



  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020