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;