MERGE语句在Informix v10中不起作用

嘉通电子科技

我尝试使用merge语句在Informix v10.0中进行插入/更新，但是会引发语法错误：
4 l" K2 Z8 \) c9 |  e. `; d  Pcreate table source(id int, account int, age int);
create table target (id int, account int, age int);
insert into source values(1, 1200, 25);
insert into source values(2, 1300, 28);
0 V: [5 p7 K  g" Y6 B  Qinsert into source values(3, 1400, 45);
merge into target t
( V% {; Q2 L" G; ^8 n  N" I3 g/ Pusing source s on t.id = s.id
& t: H9 r# V5 j, S" z5 Lwhen matched then
& |3 e+ y- q" L* p: r  P( H  Pupdate
set t.id = s.id, t.account = s.account, t.age = s.age
( z4 x9 Y. K2 c% x" ]! Z) pwhen not matched then
insert (t.id, t.account, t.age)
values (s.id, s.account, s.age);
" \4 `' q3 _" _6 O; }select * from target;
能否请你帮忙？
               
解决方案: