Hi all,
I am new in MQ stage, I want to know how to get the MQ message.
At "column" tab, many options to get MQ message information at field "Data element", e.g. MQ.CORRID, MQ.DATE. But which one is for MQ message content itself?
Many thanks.
Cheers,
Brigitta
How can I get the message from MQ?
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Hi Brigitta,
I dont have the stage installed hence cant provide you the demo job, but as far as i remenber you dont have to give a description for the message (just define the data type and its size).
Moreover, are you reading from the MQ or you are writing to the MQ?
Also it will be good to go through the MQ guide present on the CLIENT DATASTAGE installation directory (usually C:\Program Files\Ascential\DataStage7.5.1\Docs). This will help you a lot, also its pretty small so it wont take much time.
I will still try to look to the stuff you asked for.
Thanks
Sunil
I dont have the stage installed hence cant provide you the demo job, but as far as i remenber you dont have to give a description for the message (just define the data type and its size).
Moreover, are you reading from the MQ or you are writing to the MQ?
Also it will be good to go through the MQ guide present on the CLIENT DATASTAGE installation directory (usually C:\Program Files\Ascential\DataStage7.5.1\Docs). This will help you a lot, also its pretty small so it wont take much time.
I will still try to look to the stuff you asked for.
Thanks
Sunil
As Sunil says, there really are only two columns to concern yourself with.....the message ID, which is there on the output link automatically, and whatever other columns you place on the link......these additional columns function much like the Sequential stage (on Server --- where the Display length is the offset in bytes into the message buffer)...however, the easiest and safest way to get the message is to just add one other column on the output link, like "myMessage"...give it a longvarchar datatype and a length of say.... 5000 and see what you get..... there are options in there for truncation and padding, if the message is shorter or longer.
Ernie
Ernie
Ernie Ostic
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>