MQ Stage/Destructive Read/Commit at end of job

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
rcdhawan
Participant
Posts: 15
Joined: Wed Sep 12, 2007 7:04 pm

MQ Stage/Destructive Read/Commit at end of job

Post by rcdhawan »

My requirement is:

To read from MQ, do database call based on message and then write to a file. How can I maintain a transaction control in this? That means teh message should not destruct until and unless is written to file and job finished successfully.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Apparently you can browse the MQ Series queue rather than destructively reading it.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
rcdhawan
Participant
Posts: 15
Joined: Wed Sep 12, 2007 7:04 pm

Post by rcdhawan »

Reading the queue in the browse mode will levae the message in the queue and resultss in more mainteance issues. How can we implement TXN control if any in this case?
ray.wurlod wrote:Apparently you can browse the MQ Series queue rather than destructively reading it. ...
Post Reply