I want to load two columns data to the table
The latest version of fastload (well, from TTU 14.0) supports quoted vartext records. You can specify the data as "10021","Brown, Jo".
Thanks for your reply. But the file i am trying to load has more than 10,000 records and the data is like below
col1 , col2
10021 ,Brown, Jo
10001 ,Jones, Bill
10002 ,Smith, Jim
10028 ,Lee, Sandra
10029 ,Berg, Andy
10023 ,Ayer, John
It is time taking work to keep " through out the file. Is there any other option to read the file as it is and load correctly to the two columns.
10000 records is peanuts.
If I were you, I'd load the file with bteq (more versatile) with some kind of magic with SUBSTR and POSITION/INDEX.
If it's always "col1,col2,col3" you should keep the VarText, but switch to BTEQ or MLoad.
Then simply define 3 columns and INSERT(col1, col2 || ', ' || col3).
Or load three colums using FastLoad into a stage table and then INSERT/SELECT into target.
And think about if you really want kind of comma delimited data in a single column.
Another approach is you can edit the file using awk command in unix.
then after that you can use fastload using the newfile.
Here is a sample command:
The result would be:
could you please,
send me the script of
Q: how to identyfy the every one hour,insert ,update ,deleted records , records count
plz send me
can any one help me
My problem is i have a data in the file like as
1, 2, ram,yaragala,....,...., , , ,
2, 3, nag,gaddam,......,.........,.......,
3, 3, mahesh,giddaluru,.......,........,
like this i have data i need load this data into table by using ',' delemeter isf i am using ',' it is taking multiple columns but i eed to load that column 3 data into a single column.(here in the file column 3 has multiple ',' ) can you please help me
Thanks in advance