Hi

If one or mode records get deleted from t1 (see below), I'd like
delete all the corresponding records from t2. There is no foreign key
relationship between t2 and t1, so cascading delete is not an option.
V8.2 AIX

create table t1
(
x int
);
create table t2
(
y int
);

insert into t1 values (2);
insert into t2 values (2);
Can this be accomplished using before delete trigger:

create trigger some_del
no cascade before delete on t1
referencing old as old_t for each row
delete from t2 where y= old_t.x

DB21034E  The command was processed as an SQL statement because it was
not a
valid Command Line Processor command.  During SQL processing it
returned:
SQL0696N  The definition of trigger "AAA.some_del " includes an invalid
use
of correlation name or transition table name "old".  Reason code="1".
LINE
NUMBER=3.  SQLSTATE=42898

Thanks