All Forums Connectivity
caleb 3 posts Joined 01/11
25 May 2012
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
 

tomnolan 594 posts Joined 01/08
25 May 2012

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
 

You must sign in to leave a comment.