Discovering Result Sets for SQL Statement Operations

When you create stored SQL statement operations, you can discover and view their parameters and result sets. To discover result sets:

On the Service Interface page, expand the Operation Parameters section.
Click the Results Sets tab.
Click Discover.
The Discover Result Set wizard appears. This wizard walks you through the steps necessary to execute a stored procedure or SQL statement and retrieve result set metadata that can be used by the operation at runtime. After result sets have been discovered, you can modify them before adding them to the operation. If you do not want to view the Introduction page again, select the Don't Show Introduction Page Anymore checkbox.
If you prefer using the Discover Result Set dialog rather than the wizard, select the appropriate check box.
Click Next.
The wizard prompts you to add an endpoint, if not already present.
Click Next to specify input parameter variables for any parameters.
Click Next to view discovered result sets.
Use the review result sets dialog to edit, move, or add line items.
A Result Set has a name and an associated row. Each row has a set of columns. Each column has a set of properties very similar to those available for creating a parameter for a stored procedure or SQL statement operation. The properties for a column include:
- Column Name
- Mapped name
- Type
- Scale
- Precision
- Nullable
Click Finish to add the result sets to the operation.