 |
 |
Archives of the TeradataForum
Message Posted: Fri, 09 Sep 2005 @ 12:39:33 GMT
| Subj: | | Re: Urgent: Question on Teradata batch upsert |
| |
| From: | | Victor Sokovin |
| | I have heard of FastLoad or MultiLoad for mass-insertion of data. But how do I use that from Java with the NCR JDBC driver? | |
I think MultiLoad or TPump would be the only options for what you plan to accomplish (FastLoad doesn't support UPSERT, does it?) under the
restrictions you have imposed. Find out why in one of the recent threads on the subject:
www.teradataforum.com/teradata/20050724_135835.htm
.
Multiload and TPump have nothing to do with JDBC. They are just stand-alone utilities, external to the JDBC application, so there is
nothing special about their integration. One of the "modern" ways would be to use queues. Both utilities support Websphere, for instance. But then
again you might be missing the "bulk" aspect. More classical approach would be to prepare the data file and then make a call to the utility from
within the Java application. The downside is that you will need to handle exceptions, restarts etc.
Regards,
Victor
| |
