Define Input External Template File Control

Explanation

Use this activity to define specific control statements that will be used when reading an input file to decide if a file line should be handled or not. A control statement can be assigned the condition Skip or Satisfy. Control statements can also be grouped together meaning that all conditions belonging to one group are considered as AND conditions.
If more than one control group is defined then following applies: <conditions_in_group_one> OR <conditions_in_group_two> etc.

If an external file type consists of more than one record type then it is necessary to define control statements, making it possible to decide the record type that each file line is associated with. The record type then makes it possible find the detail instructions to be used when unpacking the file line.

Prerequisites

Data must have been defined in the Input Files tab in the External File Template window to be able to launch the External File Template Control window.

It is not possible to modify template control data data for a system defined file template.

System Effects

The control statements makes it possible to:

• Decide the record type that an input file line is associated with.
• Decide if an input file line should be skipped or accepted.

Window

External File Template Control

Related Window Descriptions

External File Template Control

Procedure

1. Open the External File Template window.
2. Click in the Input Files tab.
3. Right-click and then click External File Template Control.
4. In the detail window, click New.
5. Supply a unique number in the Row No column.
6. Use LOV to view and select the record type that the control statement applies to.
7. Supply a group identifier in the Group No column. All control statements that should be grouped together are given the same group identifier.
8. Define condition, Satisfy if the control statement refers to a conditions that must be fulfilled to consider the line as valid.
   Define Skip if the control statement refers to a condition that must be fulfilled to skip the line.
9. Define Column No for a column separated file or Start end End Position for a file with fixed columns. This will specify that column or value to be used when testing the condition.
10. Supply a fixed value in the Control String column that is used when testing the value in the specified column or range.
    The String Evaluate column can be used to define a system defined value that is evaluated during processing. The value in the column overrides the value in the Control String column if both are specified.
11. Click Save to save the input file template control definition.