将 DB2 数据公开为 XML / 通过 XML 查询 DB2
我有一个客户，他有一个存储在 DB2 中的数据仓库。由于多种原因，数据必须保留在该平台上。
客户正在考虑实施一个在 MySQL 中运行的开源 CMS (Drupal)。客户端需要能够从远程应用程序对 DB2 数据库执行一系列预定义的查询。
Drupal 似乎与其他系统的 XML 数据交互良好。有人建议我们使用 XML-RPC 之类的东西来对 DB2 执行查询。
我非常熟悉 SQL Server，也非常熟悉 MySQL，但我没有使用 DB2 的经验，也不了解它的功能或限制。
有没有什么方法可以使用 XML、XML-RPC 甚至 http 之类的东西来启动对 DB2 数据库的查询？
任何想法表示赞赏！
谢谢你！
I have a client who has a sort of data warehouse stored in DB2. For a variety of reasons, the data must remain on this platform.
The client is considering implementing an open-source CMS (Drupal) which runs in MySQL. The client needs to be able to execute a bunch of pre-defined queries against the DB2 database from the remote application.
Drupal appears to interact well with XML data from other systems. It was suggested that we use something like XML-RPC to execute the queries against DB2.
I am very familiar with SQL Server and pretty familiar with MySQL, but I have no experience with DB2 and no understanding of its capabilities or limitations.
Is there any way that we can use something like XML, XML-RPC, or even http to initiate queries against a DB2 database?
Any ideas are appreciated!
Thank you!
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
在 DB2 中生成和使用 XML 非常容易。 DB2 对 SQL/XML、XPath 和 XQuery 标准的 pureXML 实现是市场上最完整的实现之一。
我的建议是创建存储过程来生成 XML。
我建议将以下书籍作为出色的指南 -
http://www.ibmpressbooks.com/bookstore/product.asp?isbn=0138150478&S_TACT=105AGX01&S_CMP=TILE&ca=dti-ibmpresspurexmlcook&ca= dth-i
如果您需要任何帮助，请随时给我留言。
Producing and consuming XML in DB2 is very easy. DB2's pureXML implementation of the SQL/XML, XPath and XQuery standards is one of the most complete in the marketplace.
Creating stored procedures to produce the XML would be my recommendation.
I'd suggest the following book as an excellent guide -
http://www.ibmpressbooks.com/bookstore/product.asp?isbn=0138150478&S_TACT=105AGX01&S_CMP=TILE&ca=dti-ibmpresspurexmlcook&ca=dth-i
If you need any help then don't hesitate to drop me a line.
是的，请查看服务模块。它会在那里帮助你。您也可以在没有它的情况下实现 xmlrpc，但它有一些不错的功能。
Yes, check out the Services module. It will assist you there. You can also implement xmlrpc without it, but it has some nice features.