Use the Tables page of the SQLAssist SmartGuide to specify the tables that are accessed in a result set returned by a stored procedure.
The Table name field lists the tables that you can access in the database identified by the currently selected connection alias. By default, the tables listed are those whose schema is the user ID specified for the database connection. If no tables in the database have that schema, all the tables in the database are listed.
You can add to or remove from the table names displayed in the list by selecting View schema(s). You can filter the table names displayed in the list by selecting Filter table(s).
Selecting View schema(s) opens the Schema(s) to View window.
When you finish selecting schemas to view, select OK. This closes the Schema(s) to View window.
Selecting Filter table(s) opens the Table Name Filter window.
You are then prompted to enter the following information for the filter:
When you finish entering information that filters table names in the list, select OK. This closes the Table Name Filter window.
Select a table for the result set by checking the checkbox next to the table name in the Table name list. You can select more than one table.
When you finish, select Next. This displays the Columns page of the SQL Assist SmartGuide. Use this page to specify the columns 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 columns for a stored procedure result set
Remapping stored procedure result set data to a different SQL data
type