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:
- Restart previous run
- Reprocess rejected rec's
- 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.