By using the IBM® Database Add-Ins for Visual Studio,
you can create and deploy IBM Web services to a database on
the DB2® embedded application server.
The SQL statements in a Web service that you create
can be based on a selected table, view, procedure, or function in your IBM database.
Prerequisite: The database on the DB2 embedded application
server must be enabled
for Web services. If the database is enabled, but you have not
specified the connection information for the database, the Identify
Database Enabled for Web Services window opens when you start to create
an IBM Web service. You can provide the connection information at that time.
Note: This functionality is supported
only in Version 8 (all releases) and Version 9.1 (all releases)
of DB2 for Linux®, UNIX®,
and Windows®.
If you are using a more recent version of DB2, use
IBM data Web services.
To create an IBM Web service:
In the Server Explorer, right-click a table, view,
procedure, or function, or right-click Web Services,
and then select Deploy IBM Web Service on the shortcut menu.
Type the absolute path of the location to save
the WSDL file. For example, C:\<directory_name> .
For each type of command that you want to include
in the Web service, perform the following steps:
Expand the section for the command.
Select the Include <command_name>
check box.
If a predefined statement is displayed, accept or change
the statement; otherwise, type a new statement.
Optional: Type a description for the statement.
Select the Open test client check box to open an Internet Explorer window with
an auto-generated Java Server Page that tests
the Web service.
Using the test page, you can start each operation in the Web service
and view the results.
Optional: Change the user name and password to access the data connection.
Click OK to deploy the Web service to the DB2 embedded application
server.
To see the deployed Web service in the Server Explorer, right-click the
Web Services node under your data connection, and
then select Refresh on the shortcut menu.
After you deploy a Web service, you can use its shortcut menu in the
Server Explorer to run, redeploy, or delete the Web service.