Result Set Definitions

Result set definitions

Shows the result sets that have been defined for the procedure, based on the known values for the input parameters. Expand the Result set definitions node to see the result sets. Expand an individual result set node to see the columns in the result set.

Opens the Run Options window so that you can specify the input parameter values for which you want to discover the result set.

Add

Adds a new element to the Result set definitions list, depending on the node that is selected in the list.

• If the Result set definitions node is selected, adds a new result set definition.
• If a result set definition node is selected, adds a new column to the selected result set definition.
• If a column node is selected, adds a new column to the result set definition that contains the selected column.

Remove

Removes the selected node from the Result set definitions list. If the selected node is a result set, the columns in the result set are also removed.

Move Up

Moves the selected node up one position in the Result set definitions list.

Move Down

Moves the selected node down one position in the Result set definitions list.

Opens the Import window so that you can import columns from one or more tables into the selected result set definition.

Result set definition properties

In this grid you change or specify the properties for the column that is selected in the Result set definitions tree. An unavailable property is a limitation of the database that you are using.

Select a property to see its description in the box under the properties list. If the description exceeds the size of the box, hover the mouse pointer over the last line of text in the box. After a brief pause, the full description is shown in a ScreenTip.