Browse Tab

Use the options on the Browse tab to set preferences for browsing data and to select font characteristics for browsing a Compare File to quickly identify changed data.

personal options browse tab, explained below

Display Column Attributes

Select to display the data type, length, and nullable attributes for all columns in a selected table when browsing an Extract File, Archive File, or a Compare File. To display only column names, clear the check box.

Side Label Display

Select to display rows one at a time, with column names and values side-by-side. To display multiple rows in a columnar format, clear this check box.

Auto Switch

Select to automatically switch subordinate tables in a stack of two or more joined tables to display related rows.

When you select a row in a table and there are no related rows in the subordinate table, the display is automatically switched to the next table in the stack that has a related row.

Display Row Count

Specify the default number of rows to display for each joined table. Use row count to manage the display area when you join several tables.

Maximum Exclude Rows

Specify a row limit to improve performance when browsing an Extract, Archive, or Control File that contains a large number of rows. When browsing, the Exclude Rows and Only Show Rows in Error features are unavailable for tables that exceed the specified row limit. (When an Extract, Archive, or Control File is first opened for browsing, system resources are allocated for creating a cache for temporary storage of excluded rows and rows in error. Therefore, browsing a very large file can consume a large amount of system resources.) This limit is reevaluated when a table is joined to another table, because the resulting subset may contain fewer rows.

The default value is 100,000 rows.

When a table is browsed that contains rows in excess of the Maximum Exclude Rows value, a message displays to remind you of the specified limit.

Note: If you never expect to use the Exclude Rows or Only Show Rows in Error features, set this limit very low to optimize system performance.

Changed Data Display Attributes

Select options to identify changed data when browsing a Compare File.

Italicize Changed Columns
Select to italicize data that differs between Source 1 and Source 2.
Bold Changed Columns
Select to display the data that differs between Source 1 and Source 2 in bold type.
Color for Changed Columns
Click the down arrow to select a color to identify data that differs between Source 1 and Source 2.
Initially Display These Rows
Select rows to display by default when browsing a Compare File: All, Different, Duplicate, Equal, or Only (unmatched rows).