Archives of the TeradataForum

Message Posted: Tue, 11 Oct 2005 @ 14:55:46 GMT

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

You need to write a DECLARE CONTINUE HANDLER routine to look for SQL EXCEPTION. Within the handler you can insert the data you desire into a table.

This is documented in the Teradta reference manuals.

Regards,

Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor

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