新手、随便写了个触发器，老写不对，帮忙看看

shan桔梗 2012-03-30 11:31:43



CREATE TRIGGER .stu_tri after insert on student for each row mode db2sql

BEGIN ATOMIC

 if exists(select name from teacher where name ='张三')

  then 

      update teacher set age=100 where name='test';

  else

     insert into teacher values ('12','test',100);

  end if;

END;

...全文

237 3 打赏收藏转发到动态举报

写回复

用AI写文章

3 条回复

切换为时间正序

请发表友善的回复…

发表回复

shan桔梗 2012-03-30

打赏
举报

错误信息：

11:41:24 [CREATE - 0 row(s), 0.000 secs] [Error Code: -104, SQL State: 42601] DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=END-OF-STATEMENT;00 where name='test';<delim_semicolon>, DRIVER=3.57.82
11:41:24 [ELSE - 0 row(s), 0.000 secs] [Error Code: -104, SQL State: 42601] DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=else
insert;BEGIN-OF-STATEMENT;<insert>, DRIVER=3.57.82
11:41:24 [END - 0 row(s), 0.000 secs] [Error Code: -104, SQL State: 42601] DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=END-OF-STATEMENT;end if;JOIN <joined_table>, DRIVER=3.57.82
11:41:24 [END - 0 row(s), 0.000 secs] [Error Code: -104, SQL State: 42601] DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=END-OF-STATEMENT;END;JOIN <joined_table>, DRIVER=3.57.82
... 4 statement(s) executed, 0 row(s) affected, exec/fetch time: 0.000/0.000 sec [0 successful, 0 warnings, 4 errors]

shan桔梗 2012-03-30

打赏
举报

CREATE TRIGGER stu_tri after insert on student for each row mode db2sql
BEGIN ATOMIC
if exists(select name from teacher where name ='张三')
then
update teacher set age=100 where name='test';
else
insert into teacher values ('12','test',100);
end if;
END;

shan桔梗 2012-03-30

打赏
举报

11:38:07 [CREATE - 0 row(s), 0.000 secs] [Error Code: -104, SQL State: 42601] DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=.;CREATE TRIGGER ;<space>, DRIVER=3.57.82
11:38:07 [ELSE - 0 row(s), 0.000 secs] [Error Code: -104, SQL State: 42601] DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=else
insert;BEGIN-OF-STATEMENT;<insert>, DRIVER=3.57.82
11:38:07 [END - 0 row(s), 0.000 secs] [Error Code: -104, SQL State: 42601] DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=END-OF-STATEMENT;end if;JOIN <joined_table>, DRIVER=3.57.82
11:38:07 [END - 0 row(s), 0.000 secs] [Error Code: -104, SQL State: 42601] DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=END-OF-STATEMENT;END;JOIN <joined_table>, DRIVER=3.57.82
... 4 statement(s) executed, 0 row(s) affected, exec/fetch time: 0.000/0.000 sec [0 successful, 0 warnings, 4 errors]