Authorities
and privilegesUse the Step Properties notebook (for DB2 UDB load) to create a step that can be used to load data from a source or target file into a DB2 Universal Database table.
Note: The source or target file and the target table must be linked.
To load data into a table:
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.
Optional: On the Parameters page, specify information for the load step (the fields and controls on this page are available only if the source or target file and the target table are linked on the Process Modeler):
Select the load mode from the Load mode drop-down list. The possible values are:
INSERT - loads the table and appends data from the file to the existing table. (This is the default.)
REPLACE - loads the table and replaces all the data in the existing table.
RESTART - restarts a load process that was abnormally terminated.
TERMINATE - terminates a currently executing load process.
Optional: In the Delimiters group box, change the delimiter types by clicking on the down arrow to display a list of valid delimiters and selecting one.
The column delimiter indicates the character that is used to delimit each column in the file to be loaded.
The character delimiter indicates the character that is used to enclose character based columns in the file to be loaded.
The decimal delimiter indicates the character that is used as a decimal point in number columns in the file to be loaded.
Optional: To specify advanced options for the load step, click Advanced. The Load notebook opens.
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 file, and the step that you are defining.
If you want to have the option 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.
Click OK to accept the parameters specified in this notebook and in the advanced Load notebook, if used, and save the load step.
Related information