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
CategoryTimestampDurationMessageLinePosition
Error2011/7/14 13:17:440:00:00.021DB2 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
280
这个触发器把v_posit_realtime_test 换成普通表就能建上，是不是mqt上不能建触发器阿？
[解决办法]
不能建
