With the IBM® Database Add-Ins for Visual Studio, you can use the IBM Web Service Function Designer to create DB2® functions that can access Web services.
With the IBM Web Service Function Designer, you specify the WSDL URL that identifies the Web service and select the operation for which you want to create the function. The designer creates one function for the WSDL operation that you select.
Prerequisite: Before you can create Web service functions on a database, you must enable the SOAP requestor functions on the DB2 database. You need to do this only once on each database on which you create Web service functions.
To create a Web service function:
The IBM Web Service Function Designer opens.
For detailed information about the fields in the designer views, see IBM Web Service Function Designer.
The Web service function definition script is run and the Web service function is created in the database.
The Web service function is shown in the Functions folder of your data connection in the Server Explorer.
You can run a Web service function in the same way that you run a DB2 SQL function.
Developing Web Service Functions | Web Service Functions | Running Procedures or Functions