Archives of the TeradataForum

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

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

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>>