Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 17 Feb 2005 @ 18:45:16 GMT


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


Subj:   Re: UTY4017 Not enough data in vartext record number 1.
 
From:   Dieter Noeth

Jyotsna Malineni wrote:

  I am running a teradata multiload job that is giving me this error.  


  UTY4017 Not enough data in vartext record number 1.  


  This is a simple job that reads from sequential file and loads teradata tables.I have checked all the column definitions and also tried with all kinds of test data.  


  sequential file has char, decimal and date data types.  



If it's FORMAT VARTEXT then only VARCHAR/VARBYTE fields are allowed, nothing else.

     data: 20050217|12345.67|bla

     ct foo(
     mydate date,
     maydec dec(8,2),
     mychar char(5)
     );

     .FIELD mydate * VARCHAR(8)
     .FIELD mydec * VARCHAR(10)
     .FIELD mychar * VARCHAR(5)

MLoad will try to cast it during the insert, so maybe you have to specify a Format string:

     insert into mydate
     (:mydate (date (format 'yyyymmdd')),
       :mydec,
       :mychar
     );

Dieter



     
  <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: 15 Jun 2023