After you have browsed to select the stored procedure for an operation, do the following:
Verify that the parameters
are correct.
Modes must in in,
out, or in/out. If any parameters are returned as mode in/out, verify
the specified value and modify to out, if necessary.
Specify the mode of any parameters that are marked as unknown.
Verify that the result
sets are correct.
Remember that not all databases return result sets. If the wizard does
not discover result sets when you select the stored procedure, use the
Discover Result Sets button to execute the procedure and discover the
result sets.
You can change the result set name and row name to something more meaningful. For example, the default result set name of resultSet1 can be changed to ClientList, and the default row name of resultSet1Row can be changed to Client.