Archives of the TeradataForum

Message Posted: Thu, 10 Nov 2005 @ 13:22:16 GMT

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

Hi Srikanth,

In this scenario no you can't get any details of the failing row. The entire insert fails because it's a single request and like all/most DBMS's Teradata will enforce the following rule: "the entire transaction works or it all fails".

There is no way (that I've heard of) of finding out which row failed on an insert/select. You would either have to execute another request 'up front' which checks for invalid data or you'll have to export the data and then load it with Multiload or Fastload and use the error tables. Both approaches have their downsides.

Regards,

Dave

Ward Analytics Ltd: Information in motion ( www.ward-analytics.com )

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