I am trying to use the below records to load in to teradata database using Multiload option
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.
check the QUOTE option of FORMAT VARTEXT:
Thanks Dieter. You made my day.
It's working fine after using ( QUOTE YES ' " ' ) .
.IMPORT INFILE C:/data.txt FORMAT VARTEXT ';' QUOTE YES '"'