Sending multiple records as Single Message using MQ Connecto

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
Apotluri
Premium Member
Premium Member
Posts: 25
Joined: Sun Dec 25, 2005 10:38 pm

Sending multiple records as Single Message using MQ Connecto

Post by Apotluri »

I am trying to send multiple records as a Single Message from a sequential file to MQ Connector. I went through the documentation and tried to use 'EOL as row terminator' property in MQ connector, but found that it helps only while recieving and not to sending thru MQ Connector.

I really appriciate any input in this regard...
gvstrao
Premium Member
Premium Member
Posts: 27
Joined: Sun Jun 04, 2006 4:45 pm

Re: Sending multiple records as Single Message using MQ Conn

Post by gvstrao »

Finally I wrote a unix script and resolved the issue

Thanks

Aravind
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Are you the same person? If not, can you please post the script so that Apotluri may have an answer to the original question?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Apotluri
Premium Member
Premium Member
Posts: 25
Joined: Sun Dec 25, 2005 10:38 pm

Re: Sending multiple records as Single Message using MQ Conn

Post by Apotluri »

I found the answer

We can send multiple records in a single message using the following options in the properties tab of MQ Connector

1. Put Record Count = 0 ( this option sends all the available rows), or
if you know that the number of records as constant then put that number , for example Record count=10

2. Put Row Buffer Count = -1 , if you want to send all the records in a single message

Hope this helps

Thanks

Apotluri
Post Reply