Tables by Batch (ttmig5511m000)

Use this session to link tables to a batch. In this session you can also specify how the table for a batch code should be loaded into the LN database.

You can run these actions in the appropriate menu:

  • Generate: Use this option to generate the list for a range of tables under a batch.
  • Verify List of tables for completeness: Use this option to generate a list of expected/missing tables in the batch.
  • Bulk Update Table Properties: Use this option to update the values in the session for a range of tables simultaneously. You can set these options: Skip?, Load Option, and Mode of Loading.
Batch Code

The selected batch.

Table Name

The table code and the description linked to the batch.

Priority

Specify the load priority of a table to be processed. The 0 value is the highest priority. The 9999 (default) value is the lowest priority.

Skip?

The value in this field indicates whether the table is considered for migration. If this check box is selected, then the table is bypassed, that is, not considered, during the data load process. If this check box is cleared, the table is considered for migration.

Load Option

Indicates whether the current present data in the target table must be overwritten or retained during migration.

Possible values

Truncate If the table on the target side already has some data, then the data is deleted. During migration, data from the table on the source side is added to the table on the target side.
Append The data from the table on the source side is appended to the already existing data in the table on the target side.
Mode of Loading

The value in this field is used during the generation of the control file. The setting determines how the native database loader inserts the records into the database.

Possible values

Automatic All records are added, batch-wise. Afterwards the index check is performed, bulk load.
Conventional The records are added record by record. After each record an index check is performed, comparable to a db.insert.
Using Bulk Loading Method?

Indicates whether the load process is performed through the bulk loading method.

Possible values

Default The loading method is based on the setting in the Batches (ttmig5510m000) session.
Yes The load process always uses the bulk loading method. The Load via DAL2 option is disabled.
No The load process does not use the bulk loading method. The Load via DAL2 option is enabled.
Load via DAL2

Indicates whether the tables are loaded through DAL2 or through db.insert/ db.update. This option is available, depending on the setting of the Using Bulk Loading Method? parameter.

Load Method

Specify the database actions that are allowed when loading from DAL2.

Possible values

Update/Insert

Insert Only

Update Only

Not Applicable