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.
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.
Specifying the tables for a stored procedure result set
Remapping stored procedure result set data to a different SQL data
type