MQ Stage

rajudx · Post by **rajudx** » Thu May 16, 2013 5:40 am

Hi,

We need to push messages on one of the MQ queue.
We are planning to push messages through WebSphere_MQ_Connector stage and issues is message should be in XML format contain headr,detail records.
First we need to generate XML file then pass that XML into WebSphere_MQ_Connector stage? or directly we can write data in XML format on MQ stage?

Please let us know which option will be the best.

Thanks,
Raju.

eostic · Post by **eostic** » Thu May 16, 2013 5:46 am

You are correct in your first assumption....the xml stage provides the ability to build a potentially complex xml document and then send it downstream.....for loading to a file, a database, or in your case, to MQ.

Ernie

rajudx · Post by **rajudx** » Thu May 16, 2013 6:20 am

Hi Eostic,

You mean we need to load data on MQ through XML stage?

(To read XML file) Folder stage---->XML Stage---->MQ

Above method will work ..also we are using datastage 8.5 and in this case we need only MQ clint software on datastage box right.
Thanks for your help.

prasson_ibm · Post by **prasson_ibm** » Thu May 16, 2013 7:45 am

Hi,
Below are the steps to connect to MQ on unix server:-
1.Yes yon need to install MQ client on the server where datastage is installed if MQ server is on Different box.
2. Add mq bin and lib paths to dsenv file.
3.rerun dsenv
. ./dsenv
4.Restart the DSEngine.

5.Now on MQ connector stage you need to provide below connections:-

QUEUE MANAGER NAME
CHANNEL NAME
CONNECTION NAME

You mean we need to load data on MQ through XML stage?

Why Folder stage is required,you can use seqential file as a source and define only one column with VARCHAR and target as MQ.

rajudx · Post by **rajudx** » Thu May 16, 2013 8:49 am

You mean we can send XML messages directly from sequential file stage to MQ server with varchar(20) ?

Can we directly place XML file on MQ server using below approach.

Extrenal_stage-->MQ STAGE .

Our requirement is need to send data from DB2 to queue in XML format. For this we are first creating XML files from DB2 database and next sending XML files to MQ server.
Please let me know is there any other approach to complete above requirement.

Raju

prasson_ibm · Post by **prasson_ibm** » Thu May 16, 2013 10:40 am

Yes you can load xml into MQ using external stage.

eostic · Post by **eostic** » Thu May 16, 2013 12:07 pm

I think we're all getting confused, but I believe we're all talking about the same thing....

IF you have data in DB2 that is just "regular rows and columns" (not currently in XML format), and you want to read from DB2, generate XML and then put that XML into a queue, you can easily do this with (minimally, you may need more stages depending on the data and what you need to do with it) a DB2 Source, an XML Stage, and the MQ Connector. You do not have to first write the xml to disk --- the xml stage can delivery the whole document onto the link that directly feeds MQ.

Ernie