Catch a Duplicate row error when executing a PreparedStatement batch request

Connectivity

Catch a Duplicate row error when executing a PreparedStatement batch request

Hello all ,

Thank you for reading this .

I pull data from oracle to teradata using a PreparedStatement batch request and some data are the same .

So when I execute preparedStatement.executeBatch() method , I catch an Exception which is Duplicate row error in perf.TB_C_TMP and 

the program exits on error .

So my quertion is that why duplicate row don't batch insert to teradata , can somebody help me ? 

Tags (1)
1 REPLY

Re: Catch a Duplicate row error when executing a PreparedStatement batch request

oh , I find the problem , and  using keyword "MULTISET" insteading of "SET" can solve it when create tables .

I am beginner and can you share some docs to use teradata ? Thanks .