Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>  
Next> Last>>  

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


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.

     Layout type_rec_layout
     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.



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