Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Stored Proc calling a WEB-service

295 views
Skip to first unread message

Herb

unread,
Aug 23, 2012, 9:49:30 AM8/23/12
to
does anyone have any examples of SQL PL (ideally UDF) on UDB 9.5 or
> 9.7 , that is calling a webservice? I have searched and found some
> older examples that require turning on XML etender, but since that is
> depricated i dont want to write any new code that would us that....

Frederik Engelen

unread,
Aug 24, 2012, 7:01:54 AM8/24/12
to
On Thursday, August 23, 2012 3:49:30 PM UTC+2, Herb wrote:
> does anyone have any examples of SQL PL (ideally UDF) on UDB 9.5 or > 9.7 , that is calling a webservice? I have searched and found some > older examples that require turning on XML etender, but since that is > depricated i dont want to write any new code that would us that....

Most XML extender functions probably have a counterpart in the SQL/XML capabilities that came with PureXML, but I don't have any experience with XML Extender myself.

You might want to look into wrapping that functionality in a Java Stored Procedure and call that from you SQL/PL one.

--
Frederik Engelen

joachim....@googlemail.com

unread,
Aug 24, 2012, 8:08:49 AM8/24/12
to
Herb,

below is a link to find more about Web Services with DB2:
http://pic.dhe.ibm.com/infocenter/db2luw/v9r7/index.jsp?topic=%2Fcom.ibm.swg.im.iis.db.found.appdev.fed.ws.doc%2Ftopics%2Fiiyvfed_dev_wbsrv.html

Best regards
Joachim Müller
0 new messages