How to work with transactions using Visual Basic

[mpolito]

Hi people,

I have developed a Visual Basic application that reads a message from a queue and writes to a file by using MQAX200.
There is no problem with that apllication but I would like to know how to work with transactions in this process.
I mean, I want to read the message from the queue, but if something is wrong (example: disk full), I will leave the message intact on the queue.
If someone knows the solution, give an answer please.

Thanks,

Marcello Polito.
mpolito@dba.com.br

 

[karthik2000]

Hi,

I am new to the MQ Series, Can you explain me in what way i can read the message from teh queue and use the message for further processing. I know VB but dont know how to interact with MQ Series.

I have installed MQ Series and currently able to Communicate b/w two PCs using queue messages.

Thnx in advance
Karthik

 

[mqbrowser]

To do an MQSeries transaction you will need to set one of your Get message options properties to "Get Message Under Syncpoint." This will allow you to either "Rollback" - put the message back onto the queue if your program runs into an error. It will also allow you to "Commit" your message if your transaction goes as planned. I'm not sure of the exact syntax using the MQAX200 interface. Just make sure to set your get message property to be under syncpoint or the Commit/Rollback will not work.

Vinoo Palayoor
IBM MQSeries Certifed Specialist