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 ?
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 .