All Forums UDA
narang.mohit 13 posts Joined 07/09
15 Jul 2009
how to load data without single quotes

hi i have an OUT file which contain data like'data'|1234|'teradta'i m loadin the data with VARTEXT '|' but it loaded the data with the single quotes alsohow to load the data without single quotes is there is something inthe control file of tpump and fastload that ignore this quotes while loadingi have some 100 columns and million of data in the some 1000 files

Jimm 298 posts Joined 09/07
23 Jul 2009

Using Fastload, you will have to load the quotes and then strip them off.If you use Multiload, you can put a CASE or substring statements around the input fields.For example:Insert into tbl( col1, col2, col3 )Values(Substr(:col1,2,Chars(Trim(:col1))-2), :col2, Substr(:col3,2,Chars(Trim(:col3))-2));If you do use Fastload and then SQL to clean up, load into a work table and then insert/ Select to target table. You will be changing every row - Insert/ Select is much faster than Update every row.HTH

You must sign in to leave a comment.