Archives of the TeradataForum

Message Posted: Thu, 08 Mar 2007 @ 22:26:18 GMT

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

Of course I could say if the example I used was better, I would see the problem.

Interestingly if I put an error in my SP e.g. insert into Non_existant_table values (...);

Then I get an error, but the SP is also replaced with the error in it. If I call the SP, I get an error 3807: "Non_existant_table" does not exist.

So I'm sorry, but I don't know how to check for this other than scraping the bteq output with Perl or similar.

For what it is worth, even the error code isn't being set. So commands like:

     .compile file=t.spl
     .if errorcode > 0 then .quit 1

Doesn't cause the bteq script to abort.

It isn't even worth dropping and creating the procedure and doing a select on the procedure name from dbc.tables (and checking activity count of 0) as the erroneous procedure seems to be created.

Glenn Mc

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