Archives of the TeradataForum

Message Posted: Fri, 18 Jun 2004 @ 07:43:07 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

<-- Anonymously Posted: Thursday, June 17, 2004 18:44 -->

If you have RI constraints on the target table, then use TPUMP. And you can find the # of rows inserted or deleted by using the system variables in the script (eg: &SYSINSCNT or &SYSDELCNT).

For finding RI violations , after the load you can query the ERROR table for 2700 or 2726 or any RI related error codes.

Hope this helps.

	<Prev	Next>		<<First	<Prev	Next>	Last>>