Database services are services that interact with a database. Each operation in a database service invokes a stored procedure or SQL statement in the database. Each port in a database service specifies the database endpoint for the operations that use the port.
A database service can be as simple as a single operation and port or it can contain many operations and ports for different stored procedures and queries in different databases. Use the New Service Wizard to define a new database service.
You might consider using any of the following tools to help you provide information when creating a database operation:
SQL builder tools such as isql
Database management tools such as Sybase Central
Database visualization tools such as PowerDesigner.
Note: Parameters for Result Set and Return Value are populated automatically when you browse to the stored procedure that the operation will invoke. In other cases, you may need to manually specify the Result Set and Return Value. When defining a database operation, you may also execute the stored procedure or SQL statement to obtain information to define the operation Result Sets.
Configuring Endpoint Connections for Database Services