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
- Open the External File Template
window.
- Click in the Input Files tab.
- Right-click and then click External File Template
Control.
- In the detail window, click New.
- Supply a unique number in the Row No column.
- Use LOV to view and select the record type that the
control statement applies to.
- Supply a group identifier in the Group No
column. All control statements that should be grouped together are given the
same group identifier.
- 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.
- 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.
- 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.
- Click Save to save the input file template
control definition.