Selection fields for an initial load BOD are defined in 'Initial load.Open' (EVS006). You define one master table, up to three related tables, and the fields to be used as selection fields when executing the initial load. Up to 10 selection fields can be added.
To start a new run and perform your selections, use option 11-Run.
To view the history for a specific run, use option 12-History.
Use 'Initial load job.Open' (EVS007) to carry out the selection and execution for the initial load.
Types of selection are:
- Blank value - Only records containing a blank value in the field are selected
- Specific values - Specific value or a comma separated list of values can be specified, any records containing one of these values are selected
- Range - Only records containing values within the range are selected
- Ignored - The selection field is ignored in the selection.
Press enter on the E-panel to submit the job.
Each run is saved and can be viewed afterwards in (EVS007). That is, number of initial load records, start/end time etc.
Limitation:
Only a maximum of 10 selection fields can be added.
It is not possible to use a key field as a selection field.