Archives of the TeradataForum

Message Posted: Tue, 18 Jul 2006 @ 19:23:53 GMT

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

Christine:

In the BTEQ manual you can find references to a variable called ERRORCODE. There is actually another one you can reference called ERRORLEVEL.

BTEQ has a .if command that you might code like this -

     .if errorcode >0  then .goto errorroutine
     yada
     yada
     yada
     .label errorroutine
     yada
     yada
     yada
     .quit ERRORLEVEL   /* you could do .quit 15 where 15 is the return code
     to calling procedure */

All of this and more is in the manual.

Hope this helps,

Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor

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