mqt上能不能建触发器
我建了个mqt叫v_posit_realtime_test ,然后在上面建了个触发器
CREATE TRIGGER DB2INST1.TR_POSIT_test
AFTER UPDATE ON DB2INST1.v_posit_realtime_test
FOR EACH ROW MODE DB2SQL
BEGIN ATOMIC
insert into test1 values(12);
END
Category Timestamp Duration Message Line Position
Error 2011/7/14 13:17:44 0:00:00.021 DB2 Database Error: ERROR [42809] [IBM][DB2/LINUXX8664] SQL0159N The statement references "DB2INST1.V_POSIT_REALTIME_TEST" which identifies a(n) "MATERIALIZED QUERY TABLE" rather than a(n) "TABLE". LINE NUMBER=2. SQLSTATE=42809
28 0
这个触发器把v_posit_realtime_test 换成普通表就能建上,是不是mqt上不能建触发器阿?