Read an entry from a queue
The MQRead() function reads a message from the queue but does not remove it.
After reading the message, the queue has not been changed:
BEGIN WORK;
EXECUTE FUNCTION MQRead('IDS.DEFAULT.SERVICE', 'IDS.DEFAULT.POLICY');
(expression) hello queue
1 row(s) retrieved.
COMMIT WORK;
The following example reads a message from the queue and
inserts it into a database table:
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;