ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » General Discussion » MQ > SQL2005

Post new topic  Reply to topic
 MQ > SQL2005 « View previous topic :: View next topic » 
Author Message
gocc
PostPosted: Tue Jul 12, 2011 10:50 pm    Post subject: MQ > SQL2005 Reply with quote

Newbie

Joined: 12 Jul 2011
Posts: 1
I am sure that this question has already been asked (yes, I have tried to search through the forum but found only partial answers) but I hope that someone who can help me with answers will read this post.

The situation is like this: A db on sql2005 receive updates from an external db2 db. Previously the updates were extracted from db2 and transfered (as flatfiles) through FTP to a network location on our side. Stored procedures were used to proces files and import contents into the sql db. Pretty simple and straight forward.

The new situation is like this: MQ will be used to transfer the data from db2 side. Format that will be used is XML. I am looking for a solution that will make it possible to receive the data sent through MQ and update the sql db.

I hope that someone can help me understand how this can be done.

Thanks in advance for your time.
Back to top
View user's profile Send private message
Vitor
PostPosted: Wed Jul 13, 2011 4:59 am    Post subject: Re: MQ > SQL2005 Reply with quote

Grand High Poobah

Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
gocc wrote:
I hope that someone can help me understand how this can be done.


Stored procedure with an exit/included routine that can read a queue?

WMQ-aware application that can read a queue and update the database, in a language of your choice?

WMB? (Rather OTT for this requirement though!)

Other and possibly better solutions are undubtably possible.

AFAIK SQL2005 can't directly read a queue (like DB2 can) hence my suggestion that you'd need to include something. If it does in fact have anything like JMS support you can use that.
_________________
Honesty is the best policy.
Insanity is the best defence.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » General Discussion » MQ > SQL2005
Jump to:  



You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
Protected by Anti-Spam ACP
  
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.