Archives of the TeradataForum

Message Posted: Mon, 01 Nov 2004 @ 09:57:54 GMT

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

Neeraj,

How BTEQ captures the error? Does it have control-statement capability built in?

e.g. could I write following statement like the way I can do in Stored procedure.

     IF ret = -1 THEN
             a = 10;
     ELSE
             a = 0;
     END IF;

I am writing a procedure which returns the OUT parameter. While executing this procedure from the BTEQ script, based upon output parameter I want to throw error message to shell script. This shell script is calling BTEQ.

e.g. Following .SQL file is called by shell script. Somehow I need to throw back this output parameter 'fp' to shell script.

     LOGON tdp1/rxdoshi,rh34nr93;
             call dvd1.p1ts(fp);

     .exit

Let me know if you can provide me some info or let me know if it is there in any document.

________________________

Roopali Doshi
Enterprise Datawarehouse Group

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