Displaying journal information for a table using IBM Navigator for i

You can get journal information for a table from IBM Navigator for i. This is the one interface where you can see the entry specific data for a database table row separated by columns.

To display journal information for a table, follow these steps:
  1. From IBM Navigator for i, expand your system > Databases.
  2. Expand the database that you want to work with.
  3. Expand Schemas and the schema that contains the table for which you want to display journal information.
  4. Click Tables.
  5. Right-click the table for which you want to display journal information, and click Journaling.
  6. If the table has never been journaled, you can specify the journal that you want to use by typing the journal and library names in the appropriate fields, or by clicking the Browse button and navigating to the location of the journal that you want to use for the table.
  7. To journal before images, select the Journal image before change check box.
  8. To omit open and close entries from being journaled, clear the Include open and close entries check box.