Log Table (Batch Level) (daxch0508m000)

Use this session to view the log table that contains the results of the exchange process on the batch level.

Type of Exchange

Specifies the type of the exchange scheme.

Allowed values

Non-Regular Import

The exchange scheme was run using the session Import Data (Non-Regular) (daxch0223m000) session.

Non-Regular Export

The exchange scheme was run using the Export Data (Non-Regular) (daxch0233m000) session.

Regular Import

The exchange scheme was run using the Import Data (on a Regular Basis) (daxch0224m000) session.

Regular Export

The exchange scheme was run using the Export Data (on a Regular Basis) (daxch0234m000) session.

Exchange Scheme

Specifies the code of the exchange scheme.

Description

The description of the Exchange scheme.

Run Number

Specifies the code of the run number.

Try Number

Specifies the try number.

This sequence number is used for identification in case of multiple tries per run. The try number is required for logging purposes.

A new try number will be created if an export or import is run using one of the following options:

  1. Restart previous run
  2. Reprocess rejected rec's
  3. Continue interrupted run
Batch

The code of the batch.

Batch Sequence Number

The sequence number of the batch in an exchange process.

Batches are processed in a sequential order. Batches with identical sequence number are processed in alphabetical order.

Processing Type

Specifies the type of exchange process.

Allowed values

New run

Use this option to start a new exchange program

Restart previous run

Use this option to restart the previous runnumber

Reprocess rejected rec's

Use this option to reprocess rejected records. LN stores the rejected records in additional files:

  • Rejected Due to Error. This file contains records that are rejected because of database related problems such as index or domain errors.
  • Rejected Due to condition. This file contains records that are rejected because return values of conditions return as false.

This option can not be used if the exchange is based on an audit procedure.

Note: The option Reprocess rejected records can only be used during an import procedure.
Continue interrupted run

Use this option to continue an interrupted exchange program. The program starts at the beginning of the table relation that was not completed. You can only restart the import if more than one batch line exists. The restart can begin at the start of an incomplete batch line. If only one batch line exists, this option is the same as a complete restart.

Control Type

The Control Type depends on the exchange scheme as it was at the moment the export or import was run.

Allowed values

Full exchange

The data exchange is performed regardless of the use of indicators or audits files. The export is done from the tables and during an import every record is treated like an insert.

Based on indicators

The data exchange is based on the indicators insert, update, and delete. During an export, every record is marked with with an i, (for insert). The import depends on the indicator if the record is inserted(i), updated(u), or deleted(d).

Based on audit

The export uses the audit files for the data exchange. During the import the inserts, updates and deletes are done based on the transactions in the audit files.

User Name

The name of the user that ran the exchange program.

Processing Company

Specifies the number of the LN company involved in the exchange process.

During an export process, it represents the LN company that exports data. During an import process, it represents the LN company that receives data.