Chapter 12 Working with Web Services


Web services in IBM DB2 v8.1

PowerDesigner supports Web services for IBM DB2 v8.1.

DADX files

In IBM DB2, Web services are defined by Document Access Definition Extension (DADX) files.

A DADX file specifies a Web service through a set of operations defined by SQL statements or Document Access Definition (DAD) files.

A DAD file specifies the mapping between XML elements and DB2 tables.

For more information on DAD files, see Generating a DAD file for IBM DB2, in chapter Exchanging data with databases supporting XML, in the XML Model User's Guide .

In PowerDesigner, you can define Web services for IBM DB2 and generate their corresponding DADX file. (See Generating Web services for IBM DB2 v8.1)

Web operations types

There are five types of Web operations in IBM DB2:

Type of Web operation Description
call To invoke a stored procedure in a database
query To retrieve relational data using a SQL statement
retrieveXML To retrieve an XML document from relational data
storeXML To store an XML document as relational data
update To execute a SQL statement with optional parameters

For more information on Web operations types, see Web operation general properties in Defining Web operations properties.

 


Copyright (C) 2005. Sybase Inc. All rights reserved.