Release Notes

25.4 Support for Setting Result Set Properties

In FixPak 7, the Stored Procedure Builder has improved performance when running stored procedures that return result sets.

With the Stored Procedure Builder, you can run a stored procedure for testing purposes. Running stored procedures using the Stored Procedure Builder allows you to test for a successful build to a database and for the presence of a result set. If your stored procedure returns a large result set, you might want to limit the number of rows and columns that display in the result pane.

To edit result set properties for stored procedures:

1. Click File -> Environment Properties.
2. Click the Output tab in the Environment Properties notebook.
3. To display all rows of a stored procedure result set in the result pane, select the Display all rows check box. To limit the number of rows displayed in the result pane, clear the Display all rows check box and type a number in the Number of rows to display field.
4. To display all of the data in each column of a stored procedure result set in the result pane, select the Display all data in each column check box. To limit the column width displayed in the result pane, clear the Display all data in each column check box and type a number (representing the number of characters) in the Maximum column width field. Data is truncated to fit the specified maximum column width when it is displayed in the result pane.
5. Click OK to apply your changes.