Specifying columns for a stored procedure result set

Use the Columns page of the SQLAssist SmartGuide to specify the columns in a result set returned by a stored procedure. The columns will appear in the description of the result set.


Columns page of SQL Assist SmartGuide

  1. Select a table from the Selected table(s) drop-down list. The list includes only the tables that are selected in the Tables page.
  2. Select one or more columns from the Columns list. The list includes the columns for the selected table. Use Select all to select all the columns in the list. Use Deselect all to deselect all selected columns in the list.
  3. Select Add to add the selected columns to the Columns to include list. The selected columns are moved from the Columns list to the Columns to include list.

    To remove one or more columns from the Columns to include list, select the columns and select Remove. The selected columns are moved from the Columns to include list to the Columns list.

    To change the order of columns in the Columns to include list, select the columns whose position you would like to change and then select Move up or Move down.

When you finish specifying the result columns, select Next. This displays the Mapping page of the SQLAssist SmartGuide. Use that page to cast the data type of a result column to another data type.

Select Back to display the Tables page of the SQLAssist SmartGuide. If appropriate, you can then change the tables accessed in the result set.

You can also display any page in the SQL Assist SmartGuide by selecting its tab.

When you complete the specification of your result set, select Finish. This returns you the the Result page of the SQL Assist SmartGuide for Stored Procedures where the information about the result set is now displayed.

To cancel specification of the result set, select Cancel.


Related procedures
Specifying the tables for a stored procedure result set
Remapping stored procedure result set data to a different SQL data type