Adding database operations to Web services
To add SQL operations to Web services, you can create new SQL scripts in the
New Operation window or drag and drop existing scripts that are in a data development project onto a Web service. To add calls to stored procedures, you can also drag and drop stored procedures from the database where they are deployed onto a Web service.
- Adding operations that are based on SQL scripts
You can create operations that run any SQL statement that is supported by your database.- Adding operations that are based on calls to stored procedures
You can create operations that call any stored procedure that is deployed in your database.- Generation of default XML schemas for stored procedures that return result sets
The workbench can generate detailed or generic XML schemas for stored procedures that accept non-varying input values and return result sets that are always the same.
Previous topic: Creating Web services
Next topic: Editing Web services