how to load data without single quotes

UDA
Enthusiast

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 also
how to load the data without single quotes is there is something inthe control file of tpump and fastload that ignore this quotes while loading
i have some 100 columns and million of data in the some 1000 files
1 REPLY
Enthusiast

Re: how to load data without single quotes

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