I'm trying to figure out how to load a csv file using FASTLOADCSV option. The program works perfectly if my csv does not have double quotes around data values. The moment i get a csv file that contains double quotes around data values, the java code fails with all records going into the error table.
So a sample csv file with a record like this loads fine: A,B,C,D,E,F,G but a sample csv file with record like this fails: “A”,”B”,”C”,”D”,”E”,”F”,”G”
if i would be writing a fastload script using fastload unix utility, I can solve this issue with the statement: SET RECORD VARTEXT DELIMITER ',' QUOTE YES '"'; as mentioned in this post: https://community.teradata.com/t5/Database/fast-load-quotes-field/m-p/45783
But I don't know how to achieve this using Teradata JDBC in Java.
Any assistance is greatly appreciated.
We exchanged emails privately about this topic, but I'm responding here for the benefit of other folks who may run across this post.
JDBC FastLoad CSV does not currently support quoted field values. Our recommendation is to use a field separator that does not occur in any data value.