Using fastload from java application

Connectivity
Fan

Using fastload from java application

Hello

Can you kindly post a code snippet on how can one load data with fastload from csv in java application ?

I'm able to connect to TD via JDBC but I cannot find any useful docs with examples how to use fastload in an application.

Thank you in advance

Tags (1)
1 REPLY
Teradata Employee

Re: Using fastload from java application

The Teradata JDBC Driver Reference, with documentation and sample programs, is available here on Developer Exchange.

JDBC FastLoad (non-CSV) http://developer.teradata.com/doc/connectivity/jdbc/reference/current/jdbcug_chapter_2.html#BABFGFAF

JDBC FastLoad CSV http://developer.teradata.com/doc/connectivity/jdbc/reference/current/jdbcug_chapter_2.html#BABFGFA2

Sample programs http://developer.teradata.com/doc/connectivity/jdbc/reference/current/samplePrograms.html

Look for these specific sample programs:

T20205JD.java Insert data into a table using FastLoad with auto-commit true

T20206JD.java Insert data into a table using FastLoad with auto-commit false

T20207JD.java Insert data into a table using FastLoad with auto-commit false and verify FastLoad sessions

T20208JD.java Insert data into a table using FastLoad CSV with one CSV file

T20209JD.java Insert data into a table using FastLoad CSV with two CSV files