Archives of the TeradataForum

Message Posted: Mon, 29 Mar 2004 @ 19:41:38 GMT

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

This is what I use:

.LABEL XXXX050100
.SET ERRORLEVEL 3807 SEVERITY 0
RELEASE LOCK WORKDB.ET_DATA
,       OVERRIDE
;
.IF ERRORCODE=3807 THEN .GOTO XXXX050199
DROP TABLE WORKDB.ET_DATA
;
.LABEL XXXX050199
.SET ERRORLEVEL 3807 SEVERITY 8

The first .SET makes 3807 a non error...(the message still displays). The .IF statement bypasses code that depends upon the table being present. The last .SET turns the severity back to be condition code 8 (Each script resets any variables that have been changed)

Jim

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