Some databases do not automatically generate result sets for a database service. In this case, you have to add the result sets to the database service. You can do this manually, or you can discover the result sets using a wizard or dialog.
To add a result set:
Open the database service you want to add result sets to.
Select the Service Interface tab.
Expand the Operation Parameters section, and select the Result Sets tab.
Select the operation that you want to add result sets to.
Click Add to open the New Result Sets dialog.
Click Add Column and specify the following column values, then click OK.
New Column
| Field | Description |
|---|---|
Column Name | Enter a unique and descriptive column name. |
Column Name from Table | Enter the column name from the table. |
Data Type | Select an available data type from the drop-down list. |
Length | Enter a value to specify the length of the result set. |
Scale | Enter a value to specify the scale of the result set. |
Precision | Enter a value to specify the precision of the result set. |
Is Nullable? | Specify whether the result set is nullable. Choose from the following:
|
Click OK to close the New Result Set dialog.
The result sets are added to the Operation Parameters section of the service editor.
Click Finish to add the result sets to the operation.
Send your feedback on this help topic to Sybase Tech Pubs: pubs@sybase.com