Tags: additional, aweb, call, database, db2, java, mysql, oracle, procedure, service, servicewe, sql, stored, udb, version, web, write

Web Service call from DB2 stored procedure

On Database » DB2

1,327 words with 1 Comments; publish: Sat, 17 May 2008 11:00:00 GMT; (250113.28, « »)

Hi All,

Is it possible to write a DB2 stored procedure in Java that can call a

Web Service?

We are using DB2 UDB Version 8. Do we need any additional packages/fix

packs to existing version?

Thanks in advance,

chaiku.

All Comments

Leave a comment...

  • 1 Comments
    • On Apr 5, 12:22 pm, "cdivvela" <cdivv....db2.todaysummary.com.gmail.com> wrote:

      > Is it possible to write a DB2 stored procedure in Java that can call a

      > Web Service?

      See this documentation for information about using the Web Services

      wrapper in v8 to make a web service look like a table:

      http://publib.boulder.ibm.com/infoc...pt/clswss07.htm

      Then Stored Procedures written in any language can access them using a

      SELECT statement.

      Hope that helps,

      -Harold

      #1; Sat, 17 May 2008 11:01:00 GMT