Define External Load Parameters

Explanation

Use this activity to view current parameter values for an external load but also to modify and/or define new parameter values to be used when the input or output process is executed.

There are two main cases when this activity can be used:

If the an external output file is processed by accessing the general output method External_File_Utility_API.Create_External_Output, then the associated parameter values are mainly used to define select criteria when reading data from a source view. The parameter value can be specified according to the following:

Critera Notation
Equal 1010
Not equal !=
Larger than >
Less than <
Larger than or equal to >=
Less than or equal to <=
LIKE 10%
NOT LIKE !10%
IN 1010;1020;1030
NOT IN !1010;1020;1030
BETWEEN 1010..1030
NOT BETWEEN !1010..1030

Prerequisites

The external load must refer to a parameter set that has parameters associated with it.

System Effects

After having modified the parameter values the steps in the input or output process can be executed.

Window

External File Transactions

Related Window Descriptions

External File Transactions
External File Parameters

Procedure

  1. Open the External File Transactions window.
  2. Right-click and then click Load Parameters to launch the External File Parameters dialog.
  3. The parameters might have values assigned to them then due to the following:
  1. Modify the values of the parameters if necessary. The Help Text might supply some help regarding how to perform the input or describe possible input values.
  2. Press OK to store the modified parameters, related to the current external load header.