Tables by Batch (ttmig5511m000)
You can run these actions in the appropriate menu:
- : Use this option to generate the list for a range of tables under a batch.
- : Use this option to generate a list of expected/missing tables in the batch.
- Skip?, Load Option, and Mode of Loading. : Use this option to update the values in the session for a range of tables simultaneously. You can set these options:
- 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