To invoke a Web service using the ASE Web Services Engine, use the following procedure:
Invoking a Web service
Start the ASE Web Services Engine.
Use the add option of sp_webservices to map the Web service to a proxy table in Adaptive Server Enterprise.
Use sp_help to determine the input and output parameters needed to invoke the Web method.
Invoke the Web method with a select statement on the proxy table.