Follow-On Topics

Related Topics

# About the Recordset Tab

The Recordset tab is used to expose the recordset returned by the selected stored procedure. The procedure can then be tested to ensure that the Step has been configured correctly to return the data required.

Columns

The Columns tab provides the following:
|  | This procedure returns a recordset — This option is enabled if the procedure being used returns a recordset.
|  | Execute — When selected, the Available Parameters dialog box is displayed which lists the procedures parameters and enables values to be manually entered if required for each one. Clicking the OK button in the dialog box then closes it and displays the records returned in the Results tab. Click the image to view full size.
| Click the image to view full size.

Results

The Results tab is used to display the results of the Call Stored Procedure (OLEDB) Step when testing. The tab is automatically selected and the results displayed after the Execute button is clicked in the Columns tab and values have been entered for procedure parameters through the Available Parameters dialog box.

The tab contains the following:
|  | Results — Contains rows of results under the column selected.
|  | Limit sample record count — Specifies whether to limit the number of rows actually fetched from the data source after the procedure has been executed.
|  | If the option is checked then the number of rows displayed is limited to the number entered in the field or the number of rows returned by the procedure, whichever is less. If the option is not checked, all of the rows returned by the procedure is shown.
|  | By default, this option is checked and the number of rows to be displayed defined within the Properties tab of the Global Configuration dialog box for the connection.
| Click the image to view full size.

NOTE:

This does not limit the number of rows returned when the Task is actually run, only when testing the configuration.

The stored procedure used by this Step does not return a recordset, so it does not need to be "executed" to test the results. The Recordset tab may therefore be ignored.

Copyright © 2018 Quadrant Software B.V. All rights reserved.