Archives of the TeradataForum

Message Posted: Mon, 28 Nov 2005 @ 09:54:48 GMT

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

Is there an Exit or Return equivalent in teradata procedure language? I would like to set the returncode (an output parameter) of a proc to non-zero on failure and exit the procedure.

     ---Procedure (out returncode integer)

     If ( some_condition = 0 ) -- failure
     returncode = 100;
     EXIT;
     end if;

     other statements ..

thanks.

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