Hi All,
In a DEP if an error occurs then a certain set of events occur. Things like:
* no byref parameters are updated,
* a rollback of all statements upto the error occurs,
* execution recommences from the first statement after the one which produces the error.
So in a Row producing or Table procedure what should happen?
What if I've already generated some rows?
create procedure is_date(
a_string varchar(40) not null not default
)
result row myrow (is_date integer not null)
as declare
int_date ingresdate not null not default;
int_string varchar(40) not null not default;
a_date integer not null not default;
begin
for select :a_string into :int_string
do
int_date = date(:a_string);
select iierrornumber into :a_date;
return row (:a_date);
endfor;
end;
\p\g
declare global temporary table x_date(
a_string varchar(40) not null not default
) on commit preserve rows with norecovery;
insert into x_date(a_string) values('1/1/2011 11:13:45');
insert into x_date(a_string) values('1/11/2010');
insert into x_date(a_string) values('not a date');
insert into x_date(a_string) values('31/1/2002');
\p\g
select x.a_string, y.is_date
from x_date x, is_date(a_string = x.a_string) y
\p\g
On execution this will produce:
E_US10CE 'not a date' is not a valid date/time value.
E_QE0018 Illegal parameter in control block.
What do people think should happen here?
Marty
