Listing 1: getworkforemployee.dadx
<?xml version="1.0" encoding="UTF-8"?>
<DADX xmlns="http://schemas.ibm.com/db2/dxx/dadx">
<operation name="getWorkForEmployee">
<query>
<SQL_query>
select call__t, action_no from action 
where action_status__c != 'A501' 
and who_action__c = :employee_id
</SQL_query>
<parameter name="employee_id" type="xsd:string"/>
</query>
</operation>
</DADX>

Listing 2: updatecallstatus.dadx
<?xml version="1.0" encoding="UTF-8"?>
<DADX xmlns="http://schemas.ibm.com/db2/dxx/dadx"
xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/">
<operation name="updateCallStatus">
<wsdl:documentation>
Update the status of a call
</wsdl:documentation>
<update>
<SQL_update>
update call set call_status__c = :status_c 
where call__t = :call_id;
</SQL_update>
<parameter name="call_id" type="xsd:string"/>
<parameter name="status_c" type="xsd:string"/>
</update>
</operation>
</DADX>

Listing 3: computefirsttimeresolution.dadx
<?xml version="1.0" encoding="UTF-8"?>
<DADX xmlns="http://schemas.ibm.com/db2/dxx/dadx"
xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/">
<operation name="computeFirstTimeResolution">
<wsdl:documentation>
Call a stored procedure to compute the yearly 
first-time resolution rate
</wsdl:documentation>
<call>
<SQL_call>

call YR_RES_RATE (:emp_id)
</SQL_call>
<parameter name="emp_id" type="xsd:string"/>
</call>
</operation>
</DADX>

Listing 4: groups.properties
# /dadx group properties
dbDriver=com.ibm.db2.jdbc.app.DB2Driver
dbURL=jdbc:db2:callWS
userID=callWS
password=callWS
autoReload=true
reloadIntervalSeconds=5

Listing 5: web.xml
<?xml version="1.0" encoding="UTF-8"?>
<web-app id="WebApp_1">

...

<servlet id="CallWS">
<servlet-name>CallWS</servlet-name>
<servlet-class>com.ibm.etools.webservice.rt.dxx.serv let.DxxInvoker</servlet-class>
<init-param id="InitParam_CallWS">
<param-name>faultListener</param-name>
<param-value>org.apache.soap.server.DOMFaultListen er</param-value>
</init-param>
<load-on-startup>-1</load-on-startup>
</servlet>

...

<servlet-mapping id="CallWSMapping">
<servlet-name>CallWS</servlet-name>
<url-pattern>/CallWS/*</url-pattern>
</servlet-mapping>

...

</web-app>