DB2能不能实现这样的功能?

[shaoyadong]

在我insert or update 一个表的时候,先要判断有没有数据..
SQL Example:
If record already exist
Skip
Else
Insert record
end if;
If the field has already been updated
Skip
Else
Update the field
end if;

[Mr_Bean]

这样用触发器好些把~~~

[shaoyadong]

能不能用begin end来实现??如果能,最好给我一个简单的例子..thx

[songfrh]

merge into t using s on t.a = s.a
when matched then update ....
when not matched then insert into...

[shaoyadong]

没有实验两位说的.我就写了一个存储过程来做这工作.OK,都给分吧.