JDBC and ORacle Data Integrator


JDBC and ORacle Data Integrator

I'm trying using JDBC 12 driver to extract the number of updated, inserted, deleted rows from a multistatement in a Oracle Data Integrator Knowledge Module.

Does anyone has a clue of which functions I have to use to be able to extract these figures.
Teradata Employee

Re: JDBC and ORacle Data Integrator

We have many Sample Programs available to demonstrate features of the Teradata JDBC Driver. The Sample programs are listed on this page: http://www.teradata.com/DownloadCenter/Topic9361-99-1.aspx

In particular, sample program T20700JD.java illustrates the JDBC API methods that enable you to obtain update counts after executing a multi-statement request consisting of INSERT, UPDATE, and DELETE statements.