Run Options user preferences include determining the number of rows and columns to retrieve, as well as the default format when sampling data.

The Run Options settings pane has the following fields and options:

Maximum number of rows for test reports

Sets the number of rows retrieved to produce sample data when testing transformations or SQL. The default is 50.

Maximum number of columns for test reports

Sets the number of columns retrieved to produce sample data when testing transformations or SQL. The default is to retrieve all columns (with a highest value setting of 999999).

Test reports default format

Sets the format of reports for retrieving sample data when testing transformations or SQL. The default is Default. The following report formats are available:

• Default. Formats numeric and date columns based on edit options in the synonym.
• HTML. Produces the report in HTML format.
• HTML - plain text. Produces the report in plain text format.
• active report. Produces an HTML active report designed for offline analysis.
• Excel. Produces the report in Excel format.
• PDF. Produces the report in PDF format.
• Unformatted. Does not apply formatting to numeric and date columns.

Stop after DBMS error

Sets the number of DBMS-related errors allowed before the server stops running the procedure.