Using sp_webservices  list

Chapter 5: Using Adaptive Server Enterprise Web Services

add

The add option is used to create a proxy table for a Web method specified by a WSDL file. When the add option is used successfully, the list option is invoked automatically to describe the schema of the new proxy table.

Syntax

sp_webservices 'add', 'wsdl_uri' [, sds_name] 
[, 'web_method=proxy_table 
  [,web_method=proxy_table ]* ' ]

Parameters

Usage

If you not specify method_name and proxy_table values for a Web method, the proxy table generated for the Web method is, by default, the name of the Web method specified in the WSDL file. If there is already a proxy table with the name of this Web method, a new proxy table is generated with a name like the following:

method_nameN

where method_name is the default proxy table name, and N is a digit from 1 to 9 denoting each successive mapping of the Web method.

If you do specify method_name and proxy_table values for a Web method, the name of the proxy table must be new. If there is already a proxy table with the name specified in proxy_table, an error results, and none of the Web methods specified in the add option are mapped to proxy tables.

The output from the add option lists the methods that have been successfully mapped to proxy tables as well as those that have not been mapped. The name of a proxy table for an unmapped Web method is indicated as NULL.





Copyright © 2004. Sybase Inc. All rights reserved. list

View this book as PDF