Message read mode

The default value is Delete (under transaction).

The following values are available:

Keep

The message remains on the queue. The message is read in browse mode outside of the current transaction. Regardless of what happens to the job, the message always remains on the queue.

If the connector is part of a parallel job and you have configured the job to run on multiple nodes, setting this value produces duplicate messages because each instance of the stage independently browses the messages. To avoid this scenario, configure this stage to run on a single node by setting Execution mode on the Advanced tab to Sequential.

Delete

The message is read outside of the current transaction and is subsequently deleted. Regardless of what happens to the job, the message is always deleted from the queue.

Delete (under transaction)

The message is read from the queue within the current transaction. If the transaction is committed, the message is removed from the queue. If the transaction is rolled back, the message remains on the queue.

Move to work queue

The message is read from the source queue in the local transaction and is moved to the work queue within the same local transaction.