Archives of the TeradataForum

Message Posted: Thu, 30 Sep 2005 @ 00:33:05 GMT

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

Are you certain it's never being executed versus failing the first time and being retried automatically until it succeeds?

Use .SHOW CONTROLS to verify your settings.

You can also .SHOW ERRORMAP to see how the ERRORCODEs map to ERRORLEVELs.

If you really want it to fail on a deadlock, first .SET RETRY OFF then .SET ERRORLEVEL 2631 SEVERITY 8 and/or check ERRORCODE instead of ERRORLEVEL.

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