I am working on a code to export data from a file to Teradata. For this I am using Fastload Java API.
I am facing an issue when I try to use tab as the delimiter.
The url which I am using to create a fastload jdbc connection is as below:
I am getting the following error:
SQL State = HY000, Error Code = 1399
java.sql.SQLException: [Teradata JDBC Driver] [TeraJDBC 15.00.00.20] [Error 1399] [SQLState HY000] FIELD_SEP connection parameter value \t is not valid because it is more than 1 byte long
Can anybody tell me how we can resolve this.
Thanks & Regards
After some more analysis and trial with the code now I am getting the following exception: