Using SQL

WORF provides the run-time support for invoking DADX documents as Web services in the WebSphere application server using the Apache SOAP 2.2 (or later) engine supported by WebSphere Application Server. A DADX file specifies how to create a Web service using a set of operations that are defined by SQL statements and stored procedure calls.

You can expose any database stored procedure. WORF assumes that your stored procedures have result sets with fixed metadata (a fixed number and a fixed shape). The operation signature includes the input and output parameters. You can also specify SQL statements to select, insert, update and delete data. A simple mapping of XML schema to SQL data types is provided.

SQL operations
SQL-based querying is the ability to send SQL statements, including stored procedure calls, to DB2 and to return results with a default tagging. The data is returned using only a simple mapping of SQL data types, using column names as elements. There are three elements that make up the SQL operations type:

1. <query> - queries the database
2. <update> - inserts into a database, deletes from a database, or updates a database
3. <call> - calls stored procedures with multiple result sets