Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 27 Feb 2007 @ 22:05:03 GMT


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


Subj:   Error for .import with filter condition
 
From:   Kopuuravuri, Ramu

Hi,

I have 14 tables data in single file, now my aim is I need ti load this date into 14 tables..

All the layout's is different

     i.e tab1 has 2 columns,
         tab2 has 4 columns etc..

Hear I'm extracting the data using APPLY filter condition.

     .IMPORT INFILE
     /home/vk9187/tab_BID/tab_BID_data_feed_Reference_20070222201500_1.txt
     Layout type_rec_layout
     FORMAT VARTEXT '|'
     APPLY INS_type_rec where IN_rec_type='BTT';

Hear I'm unable to filter this records based on APPLY condition. It's trying to read all 14 tables data and giving..

"UTY4016 Data item too large for field IN_TRANS_TYPE_CD in vartext record number"

But IN_TRANS_TYPE_CD is defined with proper length.

Pls help me out is there any way to extract this data from single file with proper filter condition.


Regards,

Ramu.



     
  <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