
Figure 9-18 DADX Generation
DADX operations
The proceeding discussion used a DADX document that employed a three types of operation: query, update, and retrieveXML. The XML Collection operations use the DXX stored procedures. The SQL operations use normal SQL SELECT, UPDATE, INSERT, DELETE and CALL statements, and can be used for XML Column operations by employing the DXX UDTs and UDFs. When using the SQL operations, parameters may be defined using XSD elements as well as simple types. For the query operation, XSD elements may be associated with the column values in the result set. For call operations, parameters may be declared as in, out, or in/out.
XML Collection operations:
retrieveXML
storeXML
SQL operations:
Query
Update
Call
Chapter 9. Developing XML Web services 203