Use the New Service wizard to create a new database service.
Before you create your new service:
Determine the level of database connectivity.
See Choosing an Endpoint Binding Strategy for more information.
To create a database service:
In the Service Development perspective, select File|New|Service from the main menu bar.
The New Service wizard opens.
For other ways to access the New wizard, see Methods of Accessing New Wizards.
Select Database Service and click Next.
Select the project that uses this service.
Name the new service file with a unique and descriptive name and click Next.
From the Service Summary page, use the following information to complete the process of creating a database service.
The Service Type Information is automatically completed.
In the Service Information pane, complete the following:
Service information
| Field | Description |
|---|---|
| Name | Edit the file name. The wizard automatically enters the same name as the service file in your project. It is recommended that you keep the names consistent for easy reference in the future. |
| Category | Enter a new category, or select an existing category from the drop-down list. Note: If you plan to create multiple services, it is recommended that you group services into meaningful categories. |
| Description | Enter an internal description, such as an explanation of how and where this service is used. You can also add notes for other developers who may implement this service. |
Click Next to select stored procedures to automatically expose in the new service.
You can add stored procedures to the database service now or after the database service has been created. If you intend to define SQL statements rather than stored procedures for this database service, do not select stored procedures from the list. If you choose not to expose stored procedures at this time, go to the next step.
Stored procedures list
| Field | Description |
|---|---|
| Profile | Enter the name of your database connection profile or select it from the drop-down list. If you have not yet created a connection profile, click New. |
| Available stored procedures | Click Connect to display a list of available stored procedures and select one or more stored procedures from the list. |
The Summary page displays the information collected from previous wizard pages.
Click Finish.
The service file appears in the WorkSpace Navigator and the Database Service editor appears.
Send your feedback on this help topic to Sybase Tech Pubs: pubs@sybase.com