Archives of the TeradataForum

Message Posted: Thu, 17 Nov 2005 @ 19:39:38 GMT

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

Boris:

I am not sure what you mean because it seems you are under a very big misconception about SP. You have at your disposal both SQLCODE and SQLSTATE for checking the outcome of SQL operations. Plus you can DECLARE either and EXIT or CONTINUE HANDLER routine to take whatever action you deem appropriate. Details are available in the documentation.

Hope this gets you started on a path of less disappointment and more enlightenment.

Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor

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