Editing a Database Service Interface

The database service interface comprises the service operations that are performed during runtime and the service endpoint that enables the connection of the service to a database.

  1. Select the service in the WorkSpace Navigator.

    The Service editor opens.

  2. Select the Service Interface tab in the editor.
  3. Do any of the following:
    • Add a SQL statement operation using the Properties section
    • Add a SQL statement operation by importing query files
    • Add a SQL statement operation using Visual SQL
    • Add a stored procedure operation
    • Add a result set manually
    • Discover result sets using the wizard
    • Discover result sets using the dialog
    • View database service operation parameters and result sets
Parent topic: Developing a Database Service
Previous topic: Creating a Service
Next topic: Defining a Database Service Endpoint Binding
Related concepts
Database Services
Related tasks
Creating a Query File
Adding a SQL Statement Operation by Importing Query Files
Adding a SQL Statement Operation Using the Properties Section
Adding a SQL Statement Operation Using Visual SQL
Specifying Retrieval Arguments in a Query File
Adding a Stored Procedure Operation
Adding a Result Set Manually
Discovering Result Sets Using the Wizard
Discovering Result Sets Using the Dialog
Viewing Database Service Operation Parameters and Result Sets

Send your feedback on this help topic to Sybase Technical Publications: pubs@sybase.com

Your comments will be sent to the technical publications staff at Sybase, Inc. For product-related issues or technical support, contact Sybase Technical Support at 1-800-8SYBASE.