Now, why I use data queues rather than stored procedures:
1. Data queues allow an unlimited number of segments to a message in either
direction. I can send a multiple-record update to a server using a data
queue; I can't do that with stored procedures.
2. The segments in a message using data queues can be of different layouts.
This allows me to make a header/detail query of any complexity, and only
return the header information once. With result sets, I have to make
multiple requests, or use an inefficient JOIN request that duplicates the
header data.
Joe
> -----Original Message-----
> From: Tanveer, Mohammad
>
> Stored Procedures are very powerfull. I still wonder why people use
> MQseries, Data Ques or socket. Please help me understand.