Originally posted by: residium

Hi

Is it possible to 1) read a message from mq, do something and then 2) read the same message again.(this time using a GET command to get rid of the message). I want to do this in the same transaction.
#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender

Originally posted by: Kepa_Screen

Yes.

You can do it in several ways:

-Option 1-
Using Backup of input card of map-1. Map-1 read from mq, with data input card set with backup option to on ( to a file ). Second Map-2 reads from that file and deletes the file when complete. ( second map triggered by eventserver )

-Option 2-
Put two subscribers to de MQ. One for the Map-1 and the other one for the second Map-2. The message remains at the queue until both subscribers had read the message ( two consumers for the same queue ). Both maps must be listening to the same queue and triggered by event server.
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender

Originally posted by: janhess

Why can't you just use the mq adapter on the input card and set on success delete.
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender

Originally posted by: residium

What happens if something goes wrong in the map? My fear is that the MQ message will be lost since it is already commited/fetched by input card 1?

Or.. is the transaction based on the map as a whole? So.. if something goes wrong in outputcard 3. My MQ message will still be om the MQ queue, because it will only be commited/fetched after all the cards have reported success?

Transactional control in WTX is unclear to me.
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender

Originally posted by: janhess

If the map fails the message wont be deleted. The map should handle bad messages though so you don't go in a loop processing the same message.
#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender

Originally posted by: SystemAdmin

Do you not want to use two output cards, or, do two RUN statments from the map that reads the queue?

I've had problems in the past for real time systems if you don't read and delete, regardless of the success of the map or not. For example, if you rollback on a failure, then no more messages are going to get processed from the queue until you resolve that one bad message (unless there's a few function I'm unaware of).
#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender