5,889
社区成员
发帖
与我相关
我的任务
分享创建触发器时的错误：SQL1424N
表结构：
主表：create table test(id int not null primary key, f1 varchar(3000))
审计表：create table audit_test(id int not null primary key, f1 varchar(3000), operation char(1))
在主表上创建触发器：
create trigger audit_test_update
after update on test
referencing new as n_new old as n_old
for each row mode db2SQL
begin atomic
insert into audit_test(id, f1, operation) values(n_old.ID, n_old.F1, 'o');
insert into audit_test(id, f1, operation) values(n_new.ID, n_new.F1, 'n');
end
导致错误：
SQL1424N Too many references to transition variables and transition table columns or the row length for these references is too long. Reason code="2".
请问该问题如何解决？
主表：create table test(id int not null primary key, f1 varchar(3000))
审计表：create table audit_test(id int not null primary key, f1 varchar(3000), operation char(1))
在主表上创建触发器：
create trigger audit_test_update
after update on test
referencing new as n_new old as n_old
for each row mode db2SQL
begin atomic
insert into audit_test(id, f1, operation) values(n_old.ID, n_old.F1, 'o');
insert into audit_test(id, f1, operation) values(n_new.ID, n_new.F1, 'n');
end
导致错误：
SQL1424N Too many references to transition variables and transition table columns or the row length for these references is too long. Reason code="2".
请问该问题如何解决？
...全文
请发表友善的回复…
发表回复
comeon_data 2004-09-04
- 打赏
- 举报
up
klbt 2004-08-25
- 打赏
- 举报
帮你up
