I am facing an issue with the Teradata fastload java code. The code worked perfectly fine for |,comma and ; as delimiters but today when I tried the same I am getting exceptions like:
The default separator used by JDBC FastLoad CSV is the comma ( , )
To use a different separator with JDBC FastLoad CSV, you must specify the FIELD_SEP connection parameter. It is documented in the Teradata JDBC Driver User Guide here on Developer Exchange.
Also, keep in mind that JDBC FastLoad CSV requires an initial row of column titles, which are not inserted into the destination table. The number of columns in the column title row must match the number of columns in the subsequent data rows. This is also documented in the Teradata JDBC Driver User Guide here on Developer Exchange.
So there are at least of couple of possibilities why you are having difficulty with using a different separator:
1. Perhaps you did not specify the different separator with the FIELD_SEP connection parameter.
2. Or perhaps you changed the separator in the column titles row but not the data rows, or vice-versa.