MQRead() 函数会从队列读取消息,但不会除去消息。
BEGIN WORK; EXECUTE FUNCTION MQRead('IDS.DEFAULT.SERVICE', 'IDS.DEFAULT.POLICY'); (expression) hello queue 1 row(s) retrieved. COMMIT WORK;
INSERT into msgtable values (MQRead('IDS.DEFAULT.SERVICE', 'IDS.DEFAULT.POLICY')); 1 row(s) inserted. SELECT * from msgtable; msg hello queue 1 row(s) retrieved. COMMIT WORK;