You retrieve a message using the RECEIVE statement from a queue that has the RETENTION setting ON. What is the effect of the RECEIVE statement on the message in this particular case?

You retrieve a message using the RECEIVE statement from a queue that has the RETENTION setting ON. What is the effect of the RECEIVE statement on the message in this particular case?

You retrieve a message using the RECEIVE statement from a queue that has the RETENTION setting ON. What is the effect of the RECEIVE statement on the message in this particular case?


Answer: – The RECEIVE statement updates the status column of the queue for the retrieved message and leaves the message in the queue.

(When the RETENTION setting is ON for a queue, the messages will be kept in the queue until the conversation ends.)