Adding a Default Stored Procedure Operation

Use the database service editor to create a default stored procedure operation and to associate the operation with a stored procedure.

To add a default stored procedure operation:

In the Service Interface tab of your database service, right-click the Interface box or click the check mark in its lower right corner to invoke the context menu.
Select Add Stored Procedure Operation | Request-Response to add a default operation to the interface.
Expand the Parameters Panel to view associated parameters.
Note
A database service created using an ASE stored procedure with default parameters does not reflect these parameters in the database Service Interface. The service functions, but requires non-null parameters.
In the Parameters panel, click Browse.
The Stored Procedure Selection dialog appears.
If you have not associated a connection profile with this database service, select a profile or create a new profile, then connect.
Select from the list of available stored procedures and click OK.
The Database Operation Parameters dialog displays the Source, Parameters, and Result Sets tabs, which display the properties associated with the stored procedure.