MQSeries.net :: View topic - commiting to a database using segmentation

KIARA

Hi,
The scenario is as follows.
I have a message flow that uses message segmentation.
The offset and message id are set by the flow dynamically.
I also need to sets fields within the flow from a database table.
This all works fine as long as the flow is running. As soon as the flow stops or machine goes down or the flow changes execution group, the transaction rolls back and the next time a message is put through the flow, the message will take the original values set in the database rather than the updated values.
The database does update as I have tested this - but it only updates for the duration of the flow.
How can I get the transaction to commit from within the flow?? - I cannot use the commit option within the compute node as I am using segmentation and MQSI wont allow this as it is waiting for the last message in the segment.
When the last message in the segment arrives, this message is progated to the output and the flow creates the first message of the next segmented message, so the flow is always waiting for another segment.

Has anyone any suggestions on how I can get this flow to commit?? -
thanks
k.