To display the rows from a particular table or tables:
- Double-click the table name in the grid.
- Select names of tables in the grid, then right-click
and select Display Rows from the shortcut menu,
or select Display Rows from the File menu.
You can use ctrl or shift to select more than one table name, or use
the Select All and Invert Selection options
on the Edit menu or the grid shortcut menu.
A Browse Table Data dialog
displays data from the selected table.
Note: If you make more than
one selection, several Browse Table Data dialogs
open. Move a Browse Table Data dialog to see
other dialogs beneath.
Note: Binary data
is not displayed. Cells containing binary data are shaded. To view
binary data, use the hexadecimal display. For more information about
viewing binary data, see
Column Data Display.
Data is displayed in columnar format (as shown) or in
side label format, depending on the default setting in Personal Options.
(Refer to Personal Options for
additional information about setting display defaults.)
A browse window contains the following components:
Table
Name of
the table displays to the left of the toolbar.
Toolbar
The toolbar
allows you to select display options and menu choices for the browse
window, as follows:
- Format or

- Switch the data display between columnar and side
label format. The default format is set in Personal Options. For more
information about display formats, see Display Options.
- Options
- Display the browse window Options menu.
- Display Attributes
- Switch
between displaying and hiding column attribute information in the
column headings.
- Display Source 2
- (Available when browsing a Compare File.) Select
to display Source 2 column names and data attributes. Clear to display
Source 1 column names and data attributes.
Note: The name and label
of the table at the top of the dialog changes to reflect your selection.
- Show Unmatched Columns
- (Available when browsing a Compare File.) Display
or hide unmatched columns (columns excluded from Compare processing,
using a Column Map).
This option is available in
a columnar display only, and is disabled for tables that do not have
unmatched columns.
Note: Names
of unmatched columns are shown in the column header with a number
prefix to indicate the Source for the column.
- Show Excluded Rows
- Display
all previously excluded rows (rows are excluded using the Exclude command
on the shortcut menu). To display excluded rows individually, right-click
a row and select Show Next from the shortcut
menu.
- Access Definition
- If the Extract File or Archive File contains Large
Objects (LOBs), select Access Definition to
establish an association between a LOB and an application used to
view the LOB, as follows: From the submenu, choose Create
Local to remove LOB column associations; Reload
Default to reload the column associations from the Access
Definition stored in the file; Select... to
copy LOB column associations from an existing Access Definition; or Columns... to
open the Columns dialog to create new LOB column
associations.
For more information, see LOB Column Associations.
- Join
- Join and view data
from a related table. Data from the joined table must be in the file.
If more than one table is related to the table from which you join,
or more than one relationship exists for a pair of tables, you select
from a selection list. See Display Multiple Tables for
details.
- Unjoin
- Remove the table
and all subordinate joined tables from the Browse Table
Data dialog.
- Show/Hide
- When browsing a Control File, click the buttons
to show or hide the Status and Action columns, and to switch between
a display of all rows and a display of rows in error.
- Navigation
- In side label format, scroll to display the first
row, previous row, next row, or last row, respectively.
Grid Details
Data
from the table named on the title bar displays in the grid. The display
can be navigated and customized using the Find, Exclude, Include, Hide,
and Lock options available on the grid heading
shortcut menu. (See Main Window, Menus, and Dialogs for additional information.) When you are browsing
a Control File, the grid includes status and action information that
can be switched on and off with the toolbar buttons.
- Current Row
Indicator
- Position the Current Row Indicator to display related
rows in joined table(s). To move to a different row, click the grid
cell for the desired row or use the up/down arrows on your keyboard.
See Display Multiple Tables for details.
Note: The Current Row
Indicator grid column and the Status grid column are displayed in
columnar format only.
- Status
- For
a Control File, the status of the row is displayed. If the row processed
successfully, the status is OK. If not, a brief
description of the error is displayed (most errors are self-explanatory):
- Unprocessed
- The row was not part of the process, the process
was aborted, or the process has not been performed.
- Postponed
- The row could not be processed due to RI rules,
but has the potential to be processed successfully later in the cycle.
This status indicates that the process terminated before the row could
be reprocessed.
- DB: n
- The row could not be processed due to a database
error. Refer to the DBMS documentation for an explanation of database
error codes.
- Referential Integrity Error
- The row could not be processed because of a violation
of RI rules defined to the DBMS. This status is provided after retrying
a row in a cycle and the row is not successfully inserted when the
process completes. (Note that when a cycle is not involved, a diagnostic
error message is displayed.)
- Conversion Error
- The row was discarded because one or more columns
could not be properly converted from the Extract File format to the
database format. This can occur when the Extract File column contains
NULL and the DBMS column is defined as NOT NULL or when the Extract
File column value and the DBMS column data types are not compatible.
This row cannot be restarted or retried.
- Act
- For a Control File, the type of process performed,
such as Upd for update, Ins for insert, or Del for
Delete.
Grid Shortcut Menu Commands
Right-click a grid cell to display the following shortcut
menu commands.
- Join
- Join and view data from a related table. Data from
the joined table must be in the file. For more information, see Display Multiple Tables.
- Display
- Open the Column Data Display dialog
for viewing character or hexadecimal value of a cell in a column defined
as a character, BLOB, or CLOB data type. Select the format of the
data, Character or Hex.
For more information, see Display Options.
- Character
- Display data offset information and the character
representation of the data in the cell.
- Hex
- Displays data offset information and the character
and hexadecimal representations of the data in the cell.
- Side Label Display
- Display data in side label format. Available with
columnar display only. For more information about display formats,
see Display Options.
- Columnar Display
- Display data in columnar format. Available with
side label display only. For more information about display formats,
see Display Options.
- Exclude
- Remove the row from the display.
- Show Next
- Display the first excluded row after the row you
right-clicked.
- Show All
- Display all excluded rows between the row you right-clicked
and the next displayed row.
Note: To display all excluded rows in
the grid, select Show Excluded Rows from the Tools menu.
- Access Definition
- If the Extract File or Archive File contains Large
Objects (LOBs), select Access Definition to
establish an association between a LOB and an application used to
view the LOB, as follows: From the submenu, choose Create
Local to remove LOB column associations; Reload
Default to reload the column associations from the Access
Definition stored in the file; Select... to
copy LOB column associations from an existing Access Definition; or Columns... to
open the Columns dialog to create new LOB column
associations.
For more information, see LOB Columns.
- Run Associated Application
- For cells containing LOBs, open the selected object
with the associated application.
Note: If an object association has
not been established, you will be prompted to create one using the
Columns dialog.
For more information, see
Columns.
- Export LOB
- For cells containing LOBs, export LOB data to a
file.