Space announcements

   

This space provides the same content as before, but the organization of the home page has changed. The content is now organized based on logical branches instead of legacy book titles. We hope that the new structure will help you quickly find the content that you need.

Layout of records in load files

Each record in an output load file represents a log record selected by your filter and time frame.

In addition to the row image (or images) of the log record, Log Master includes additional informational columns to give context to the record. The following paragraphs summarize the layout of an output load file record.

  • Load record header

    The header contains all of the additional informational columns that Log Master includes with the log record. The length and content of the header varies depending on the values of the INFO COLUMNS or URID FIELDS keywords. For more information, see INFO COLUMNS.

  • Row image

    Depending on the type of database action that the load record represents, and the value of the UPDATES keyword, the content of the row image is as follows:

    • Insert action—an image of the inserted row

    • Delete action—an image of the deleted row

    • Update action—an image of the row after the update is completed

    • Mass delete action—an image with all default column values

    • Exchange action—an image with the same load column information leading to the record type, followed by the clone table creator and the clone table name

      Note

      The format of the exchange record is different than the rest of the load records because it does not have the column values.

    • Additional row image (when required)

      If the load record represents an update action, the record includes another row image that contains the before image of the row.

The UPDATES keyword determines the position and content of the row image (or images) in an output load file. The following figure shows the layout of row images for each value of the UPDATES keyword.

Load file record layout for different UPDATES values




Was this page helpful? Yes No Submitting... Thank you

Comments