<div>
DB2 UDB 9.7 supports external stored procedures, which means you can write stored procedures in C,C++, Java, .NET CLR languages,or COBOL.<br />
<br />
So, yes, you can certainly create a stored procedure that calls a web service.<br />
<br />
- Gary Patterson
</div>


DB2 UDB 9.7 supports external stored procedures, which means you can write stored procedures in C,C++, Java, .NET CLR languages,or COBOL.

So, yes, you can certainly create a stored procedure that calls a web service.

- Gary Patterson

<div>
Thanks! Do you have any example you can share with me?
</div>


Thanks! Do you have any example you can share with me?

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
&nbsp; I have a web service that takes an input variable and displays an output variable.<br />
&nbsp; Can i embed this webservice in a DB2 stored Procedure and do some manipulations on my side? I'm on DB2 9.7<br />
<br />
Thanks!
</div>
</div>


Hi,

  I have a web service that takes an input variable and displays an output variable.
  Can i embed this webservice in a DB2 stored Procedure and do some manipulations on my side? I'm on DB2 9.7

Thanks!

Web Service in Stored Procedure

IBM DB2 is a family of relational database server products developed by IBM that have been extended to support object-relational features and non-relational structures like JSON and XML. There are three main products in the DB2 family: DB2 for Linux, UNIX and Windows (informally known as DB2 LUW), DB2 for z/OS (mainframe), and DB2 for i (formerly OS/400), plus a version for IBM's Virtual Storage Extended (VSE) operating system.

COBOL (Common Business-Oriented Language) is a programming language with English-like syntax. It is readable but verbose compared to other programming languages. CODASYL (Conference on Data Systems Languages) created COBOL in 1959 based on design work from Grace Hopper. It was standardized in 1968. COBOL is still present in large-scale batch processing and transaction processing where legacy applications are being used, usually in government, financial, and administrative systems.