Create External Load
Explanation
Use this activity to create an external load header to be used
for further processing of input or output files.
This is useful if the input or output process should be
executed in steps, where each step can be verified and examined manually. A
typical situation is when a new file type and/or template has been created and
the definitions must be validated. First start by creating an external load
header, then
add parameters if any and then perform the input steps or the
output steps one-by-one.
Prerequisites
- An external file type must be available.
- A parameter set must be available if it is required
to supply parameter values during the input phase.
- A valid and active file template with template
definitions for input and/or output files that is associated with the file
type must be available.
- If an input file is specified then the path+file
must be valid. If an output file is specified then the file path must be
valid. If Online processing is ordered then the input file or path for
the output file can be validated at input. If Batch processing then the
supplied path and file name can only be validated by the server process during
execution. In this case it is important to make sure that the path is valid
and can be reached by the Oracle Server.
System Effects
An external load is created with state Empty and can be seen in the
External File Transactions window. The load can be referred to when
continuing with further steps in the input or output process.
Window
External File Transactions
Related Window Descriptions
External File Transactions
Procedure
- Open the External File Transactions window.
- Click New.
- Supply external file type. Use List Of Values to
view available file types.
- Supply parameter set if the default one should not be
used.
- Supply external file template. Available templates
are those that are valid, active, have template definitions for input
and/or output files and that are associated with the external file type.
- Change Input Direction if necessary. It is
not possible to change input direction if the template definition does not
support the chosen direction.
- Supply path and file name for input file and output
file handling. Click Browse to browse the network for file (input) or
path (output).
- Click Save to save the external load
definition.