Use the IBM Web Service window to create and
deploy an IBM Web service for the SQL commands.
A DB2® Web service is
deployed on the DB2 embedded application server.
Before you can deploy a Web service, a
database must be enabled on the DB2 embedded
application server.
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 open the IBM Web Service window:
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.
Web service name
Type the name of the Web service. A predefined name is provided,
but you can change the name.
Description
Type a description for the Web service.
WSDL location
Type the absolute path of the location to save the WSDL
file. For example, C:\<directory_name> .
Select Command
In this section, you specify the statement for a SELECT command.
Include Select
Select the check box to include the SELECT command in the Web
service. If you select the check box, accept or change the
predefined SELECT statement.
Description
If you select the Include Select check box,
optionally type a description for the SELECT statement.
Insert Command
In this section, you specify the statement for an INSERT command.
Include Insert
Select the check box to include the INSERT command in the Web
service. If you select the check box, accept or change the
predefined INSERT statement, if one is displayed, or type
a new INSERT statement.
Description
If you select the Include Insert check box,
optionally type a description for the INSERT statement.
Update Command
In this section, you specify the statement for an UPDATE command.
Include Update
Select the check box to include the UPDATE command in the Web
service. If you select the check box, accept or change the
predefined UPDATE statement, if one is displayed, or type
a new UPDATE statement.
Description
If you select the Include Update check box,
optionally type a description for the UPDATE statement.
Delete Command
In this section, you specify the statement for a DELETE command.
Include Delete
Select the check box to include the DELETE command in the Web
service. If you select the check box, accept or change the
predefined DELETE statement, if one is displayed, or type
a new DELETE statement.
Description
If you select the Include Delete check box,
optionally type a description for the DELETE statement.
Specify Advanced Options
In this section, you indicate whether to test the Web service,
and provide the access information for testing.
Open test client
Select the check box to open an Internet Explorer window
with an autogenerated Java Server Page that
tests the Web service. Using the test page, you can invoke each
operation in the Web service and view the
results.
User Name
Optionally change the user name to use to access
the data connection.
Password
Optionally change the password to use to access
the data connection.