After you create stored procedures operations or write SQL statements, you can view their parameters and result sets. You can also add, remove, or reorder parameters from this location.
To view parameters and result sets:
Select the Service Interface tab.
Select the operation and expand the Operation Parameters section, and choose from the following:
View the operation parameters and any return values for your operation. Select the Parameters tab.
Add, remove, or reorder parameters. Caution should be exercised when performing these tasks as your service may fail at runtime.
Display all advanced parameters. Select the Show Advanced Parameters check box.
Advanced Parameters
| Type | Description |
|---|---|
UpdateCounts | Displays the number of rows that are updated by the stored procedure or SQL statement during runtime. |
Warnings | Provides a list of potential problems that occur during runtime. This list is generated even if the execution is successful. |
Fault | Provides a list of SQL exceptions that occur during a failed execution. |
View the result sets. Select the Result Sets tab.
Because some databases may not automatically generate result sets, you may have to add them. Choose from the following:
Send your feedback on this help topic to Sybase Tech Pubs: pubs@sybase.com