| Author |
Message
|
| Viy |
 Posted: Wed May 10, 2006 5:39 am Post subject: trigger on the queue to start a SQL Server stored pro |
 |
|
Newbie
Joined: 10 May 2006
Posts: 3
|
| I will need to have some changes done to MQ Queue for my application. We need to set up a trigger on the queue that will start a SQL Server stored procedure and pass the IPT information as a parameter to the procedure. Can you pls give me some in put on this?. I am new to MQ. |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Wed May 10, 2006 6:12 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
You have to write a program that will read the message on the queue, gather whatever information you need from the message, and connect to SQLServer and call the stored procedure with the information it needs.
Then you can configure the queue to trigger your program.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| Viy |
| Posted: Wed May 10, 2006 6:27 am Post subject: |
|
|
Newbie
Joined: 10 May 2006
Posts: 3
|
Hi jefflowrey,
Can you pls tell me the best scripting language to use?. Do you have, any examples for this kind of problem?. I try to search, I did not find one. |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Wed May 10, 2006 6:42 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
There is no "best" scripting language.
Please do your own work, thanks.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| wschutz |
| Posted: Wed May 10, 2006 6:44 am Post subject: |
|
|
Jedi Knight
Joined: 02 Jun 2005
Posts: 3316
Location: IBM (retired)
|
| Viy wrote: |
Hi jefflowrey,
Can you pls tell me the best scripting language to use?. Do you have, any examples for this kind of problem?. I try to search, I did not find one. |
What languages do you know? it seems that any language that is able to call a stored procedure should do.... (c, c++, java, perl, php, cobol, c# ......)
_________________
-wayne |
|
| Back to top |
|
|
| Viy |
| Posted: Wed May 10, 2006 6:59 am Post subject: |
|
|
Newbie
Joined: 10 May 2006
Posts: 3
|
|
| Back to top |
|
|
| jefflowrey |
| Posted: Wed May 10, 2006 7:08 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
Then for you, the "best" languages are C, Java, and Perl.
There are easily findable samples for each of those languages that show how to interact with MQ.
I assume there are also samples for each of those languages that show how to interact with a database, which should not change much for calling a stored procedure.
Putting the two things together is also easily done.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
|
|
