Reading an Entry from a Queue

The MQRead() function 3reads a message from the queue but does not remove it. After reading 3the message, the queue has not been changed:

BEGIN WORK;
3
3EXECUTE FUNCTION MQRead('IDS.DEFAULT.SERVICE', 'IDS.DEFAULT.POLICY');
3
3(expression) hello queue
3
31 row(s) retrieved.
3
3COMMIT WORK;

The following example reads a message from the queue and inserts 3it into a database table:

INSERT into msgtable values (MQRead('IDS.DEFAULT.SERVICE', 'IDS.DEFAULT.POLICY'));
3
31 row(s) inserted.
3
3SELECT * from msgtable;
3
3msg hello queue
3
31 row(s) retrieved.
3
3COMMIT WORK;