Unable to load double quoted values using Multiload option

General

Unable to load double quoted values using Multiload option

Dear All,

I am trying to use the below records to load in to teradata database using Multiload option

"100289";"ASDF"

"100358";"2610"

When i tried to load using Multi load the inserts are done automatically to the Error tables. The reason is due double quoted vaules.

The same i tried to load using the fastload option and it was sucessfull. But My client needs the option for Incremental load.

Is there any clue to load double quoted value using Multi load option. Waiting for your positive feedback

Thanks in Advance.

Regards

Karthick

Tags (2)
2 REPLIES
Senior Apprentice

Re: Unable to load double quoted values using Multiload option

Re: Unable to load double quoted values using Multiload option

Thanks Dieter. You made my day.

It's working fine after using  ( QUOTE YES ' " ' ) .

.IMPORT INFILE C:/data.txt  FORMAT VARTEXT ';' QUOTE YES '"'