Authorities
and privilegesUse the DB2 UDB for AS/400 Data Load Replace (VWPLOADR) program to load data from a flat file to a DB2 UDB for AS/400 table. The load operation completely replaces existing data in the table.
Before you define this step, you must connect it to a warehouse source and a warehouse target. You can make changes to the step only when the step is in development mode.
To define a DB2 UDB for AS/400 load replace program:
Specify information for your step:
In the Name field, you can type a new name for the step. Otherwise, you can keep the name that the Data Warehouse Center automatically supplied for the step. This field is required.
In the Administrator field, type the name of the person who is responsible for the maintenance of this step. This field is optional.
In the Description field, type a business description for your step. This description can be a maximum of 255 characters. This field is optional.
In the Notes field, type detailed information that might be helpful to users who can access this step. This field is optional.
Click the Parameters tab.
Optional: If you want to specify the delimiters of your load program, click Specify only the delimiters of the MODSTRING. If you do not click this radio button, the default entries in the Record, Column, Character strings, and Decimal point fields are assumed to be correct.
If you clicked Specify only the delimiters of the MODSTRING, specify the delimiters for your load program:
In the Record list, specify how you want to indicate the end of record.
In the Column list, specify the character that you want to use as a column delimiter.
In the Character strings field, specify the character that you want to use to indicate character strings.
In the Decimal point field, click the character that you want to use to indicate a decimal point.
If you want to add additional parameters to the program, click Type Modstring parameters. Then, type your parameters in the field below this radio button.
On the Processing Options page, in the Agent Site list, select an agent site where you want your step to run. The selections in this list are agent sites that are common to the source tables, the target table, and the transformer or program that you are defining.
If you want to have the option to to run your step at any time, select the Run on demand checkbox. Your step must be in test or production mode before you can run it.
Optional: Select the Populate externally check box if the step is populated externally, meaning that it is invoked in some way other than by the Data Warehouse Center. The step does not have to have any other means of running in the Data Warehouse Center in order to change the mode to production.
If Populate externally is not selected, then the step must either have a schedule, be linked to a transient table that is input to another step, or be started by another program in order to change the mode to production.
In the Retry area, specify how many times you want the step to run again if it needs to be retried and the amount of time that you want to pass before the next run of the step.
In the Log table list, select a log table.
Optional: In the Trace level field, specify a trace level.
Click OK to save your changes and close the step notebook.
Related information