Configure a mapping task for a mapping with a Db2 for i source. When you run the mapping task, the Db2 for i data records are transmitted to the target. You cannot run mappings for Db2 for i.
Note: SQL ELT optimization and Visio templates are not supported for Db2 for i mapping tasks.
To begin configuring a mapping task, perform one of the following actions:
•In Data Integration, click New > Mapping Task and then click Create.
•While the mapping is open, select New Mapping Task from the Actions menu.
Then enter information on some or all of the following pages in the mapping task wizard:
•Definition. Enter a name for the mapping task, a project or folder location for the mapping task, and the runtime environment that contains the Secure Agent or Secure Agent Group under which the mapping task will run. If you began creating the mapping task without first opening the mapping, you must also select the mapping with which to associate the mapping task. The description is optional.
•Sources. This page appears only if you defined a parameter for the connection. If you defined a connection parameter, select or create the specific connection that you want the mapping task to use.
•Targets. This page appears only if you defined a parameter for the target connection or object in the mapping. For more information about configuring targets in mapping tasks, click the help icon on this page.
•Runtime Options. Optionally define a schedule for running the mapping task.
Properties for parameterized sources and connections
The Sources page appears in the mapping task wizard if you defined a parameter for the connection or source object in the associated mapping.
If you defined a parameter for the source connection in the mapping, you must select or create a specific connection for the mapping task. Ensure that the connection type is consistent with the source object type. After a connection is selected, you can click Advanced Options to configure the optional Filter Overrides or SQL Query Override advanced property. For more information about these properties, see Db2 for i source properties in mappings.
Note: If the mapping uses a specific source connection and a parameter for the source object, you can specify these properties in the mapping and also specify them in the mapping task. In this case, the properties in the mapping task override those in the mapping.
If you defined a parameter for the source object in the mapping, you must select a specific source object for the mapping task. After you select a source object, the Preview All Columns button appears under Data Preview. However, you cannot preview data for a source object.
When you finish entering information on the Sources page, click Validate to validate your entries and then click Next to proceed to the Runtime page.
Note: If the mapping specifies a connection parameter and you edit the mapping to change the source object, check the specific connection in the mapping task to determine if you need to reset it and then Validate the mapping task again.