Run Samples

The DB2 Web Services samples demonstrate accessing DB2 databases using SQL defined in XML based DADX files. The samples use various databases, stored procedures and XML extenders. The samples are grouped below based on the resources they access and their type. Samples not listed below can be found in the samples application. Refer to Development for information on working with all of the samples or developing your own DB2 Web Services.

You can select links below to run specific DB2 Web services or all services defined in a corresponding DADX file. Select the corresponding DADX file link to view the DB2 Web service definition that is processed by WORF.

Before running the samples below, be sure that you first configure the required resources (databases, stored procedures. Note that you only need to configure the resources associated with the sample.

The following samples return XML documents, containing database data or return codes. A return code value of '1' means successful and a return code value of '0' means failure.

When running the samples using Microsoft Internet Explorer, you may see the result "This page cannot be found" instead of an error message. To see error messages, you can either use a Netscape browser or configure Internet Explorer to display them. To configure Internet Explorer, select Internet Options from the Tools menu and click on "Show friendly HTTP error messages" in the Advanced tab.

SAMPLES Database - the following samples use the DEPARTMENT and EMPLOYEE tables in the SAMPLES database.

1. Selected services
   • Current Time Query - query current system time using the DADX file ivt.dadx
   • List Departments - list all departments using the DADX file list.dadx
   • List Employees - list all employees using the DADX file list.dadx
2. All services (using a WORF test page)
   • List Departments and Employees - list all departments and employees using the DADX file list.dadx

TRAVEL Database - the following samples use the DEMO.CITY_TAB table in the TRAVEL database.

1. Selected services
   • Find City By Zip Code - retrieve the city for zip code 60631 using the DADX file ZipCity.dadx
   • Add Zip Code - add the zip code for Rochester, MN using the DADX file ZipCity.dadx
   • Delete Zip Code - delete the zip code for Rochester, MN using the DADX file ZipCity.dadx
   • List Zip Codes and Cities - Lists all the zip codes and cities using the DADX file ZipCodes.dadx
2. All services (using a WORF test page)
   • Manage Zip Codes - manage zip codes by listing, adding, deleting and updating them using the DADX file ZipCity.dadx

XML Extenders - the following samples use XML extenders with the SAMPLE database.

1. Selected services
   • Department List - list all departments using the DADX file list.dadx
2. All services (using a WORF test page)
   • Manage Departments - manage list of departments using the DADX file department.dadx
   • Manage Human Resources - manages human resource information using the DADX file HumanResourcesImpl.dadx

Stored Procedures - the following samples use stored procedures.

• All services (using a WORF test page) using the DADX file Spserver.dadx

Try invoking the service again, if you get the following error returned when invoking these services:
Error 400: java.lang.Exception: Connection error SQL system error.