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.
sp_webservices 'add', 'wsdl_uri' [, sds_name] [, 'web_method=proxy_table [,web_method=proxy_table ]* ' ]
wsdluri
The location for the WSDL file to be mapped to the new proxy table. If this parameter is specified, Web Services ensures that the URI exists in the syswsdl table.
sds_name
The name specified for the Web Services Consumer in the interfaces or sql.ini file. The default value is ws. If no entry exists in the sysattributes table, an error results.
method_name
The name of the Web method to be mapped to a proxy table. The method_name specified must be the name of a Web method specified in the associated WSDL file.
proxy_table
The name of proxy table to which the Web method specified in method_name is mapped.
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. |
![]() |