Chapter 12 Working with Web Services


Web services in Sybase ASA 9

Web services types

In Sybase ASA 9, there are five types of Web services:

Type of Web service Description
RAW The result set of the SQL statement or procedure is sent to the client without any additional formatting
XML The result set of the SQL statement or procedure is assumed to be XML. If it is not, then the result set is converted to XML RAW format
HTML The result set of the SQL statement or procedure is formatted as an HTML document with a table containing the rows and columns
SOAP The request must be a valid SOAP (Simple Object Access Protocol) request, and the result set is formatted as a SOAP response
DISH A DISH service acts as a proxy for a group of SOAP services and generates a WSDL (Web Services Description Language) file for each of its SOAP services.

When you create a DISH service, you must specify a prefix name for all the SOAP services to which the DISH service applies. In PowerDesigner, the prefix name is defined in the Extended Attributes page of a Web service property sheet

In PowerDesigner, the type of Web service is defined in the Service Type property of a Web Service property sheet (Only available with ASA 9).

WARNING! 

Caution
The SOAP type is not available in the Service Type dropdown listbox. SOAP Web services are handled in PowerDesigner as Web operations of DISH Web services.

HTTP Web services

A Web service invoked in an HTTP request can have a RAW, HTML or XML format.

When several Web services concern the same table in a database, their name usually starts with the name of the table, followed by a slash and a specific name identifying the query (e.g. Customer/List, Customer/Name). In that case, the name of the table is called the local path. In PowerDesigner, the local path is defined in the General page of a Web service property sheet.

Web services in ASA 9 with the same local path are considered in PowerDesigner as Web operations of the same Web service with the local path name.

SOAP Web services

A Web service invoked in a SOAP request can have a SOAP or a DISH format.

A SOAP Web service in ASA 9 is considered as a Web operation of a DISH Web service in PowerDesigner.

Implementation (SQL statement)

When you create a Web service in Sybase ASA 9, you must type a SQL statement to select which data you want to retrieve from the database. For DISH Web services, SQL statements are defined in the SOAP Web services bearing their prefix name.

In PowerDesigner, you define the SQL statement of a Web service in the Implementation page of its Web operation(s).

 


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