Authorities
and privilegesUse the Step Properties notebook (for DB2 UDB export) to create a step that can be used to export data from a DB2 Universal Database table or view to a file located at the agent site.
The database server does not need to be on the agent site. However, the target file must be on the agent site. Specify the name of the target file as it is used on the agent site.
DB2 UDB export creates the target file if it does not exist, and replaces it if it exists.
Note: The source table, or view, and the target file must be linked.
To export data from a table or view:
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 export step (the fields and controls on this page are available only if the step has a source table or view and a target file linked on the Process Modeler):
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 exported to the target file.
The character delimiter indicates the character that is used to enclose character based columns that are exported to the target file
The decimal delimiter indicates the character that is used as a decimal point in number columns that are exported to the target file.
Optional: Create or update SQL statements in the SELECT statement field:
Click Build SQL to launch SQL Assist, which will help you build and generate the SQL statements. The Build SQL window opens.
Click Edit to edit the SQL statements shown. The SQL statement field becomes editable.
Click Test to test the SQL statements shown. The Sample Contents window opens.
Click Clear to clear the SQL statements shown. The SQL statements in the SELECT statement field are deleted.
Optional: To specify advanced options for the export step, click Advanced. The Export 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 Export notebook, if used, and save the export step.
Related information
For information about the format of delimited files, see the Administration Guide.