Archives of the TeradataForum
Message Posted: Tue, 27 Feb 2007 @ 22:05:03 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|