Authorities
and privilegesThis step is intended for Data Warehouse Center users who previously used Visual Warehouse Version 5.2.
Use this step to run the Visual Warehouse DB2 UDB Data Export (VWPEXPT1) program in the Data Warehouse Center. You use the Data Export program to export data from the local DB2 UDB database.
The database server does not need to be on the agent site. However, the target file must be on the database server. Specify the name of the target file as it is used on the DB2 server.
If the export process generates warnings, the program returns as successfully completed.
To define a DB2 UDB Data Export (VWPEXPT1) Data Warehouse Center program:
Specify information for your step. You can enter information into any of these fields. None are required.
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.
In the Administrator field, type the name of the person who is responsible for the maintenance of this step.
In the Description field, type a business description for your agent definition. This description can be a maximum of 255 characters.
In the Notes field, type detailed information that might be helpful to users who can access this step.
In the Update Security Group drop-down list, you can authorize access to the step. This list contains only security groups that your current user ID belongs to.
Optional: On the Parameters page, double-click the Parameter value field for the File type modifier string parameter, and type the file type modifier string.
For example, the File type modifier string parameter
"coldel,"
indicates that columns must be separated by commas. Do not insert a space between coldel and ,. Make sure that you enclose this parameter in double quotes. Otherwise, the command line interprets some characters as file redirection characters.
On the Processing Options page, in the Agent Sites 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.
Click OK to save your changes and close the step notebook.
Related information