|
|
Archives of the TeradataForum
Message Posted: Thu, 08 Mar 2007 @ 21:54:50 GMT
Subj: | | Re: Exiting on BTEQ errors |
|
From: | | McCall, Glenn David |
| But, I am still having the same issue of exiting bteq when compile stored procedures. The stored procedure has compile errors but the bteq
script does not exit. | |
Hmmm, what more can I say? Perhaps you need to post an example!
+---------+---------+---------+---------+---------+---------+
.set maxerror 1
+---------+---------+---------+---------+---------+---------+
create procedure test ()
(
insert into gmc_sp_test values (current_timestamp);
);
$
*** Failure 3706 Syntax error: Invalid SQL Statement.
Statement# 1, Info =26
*** Exiting...
| |