Display Table Data

To display the rows from a particular table or tables:

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.
browse table data dialog, described below
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.