Configure a mapping task for a mapping with a VSAM source. When you run the mapping task, the VSAM records are transmitted to the target.
Note: SQL ELT optimization and Visio templates are not supported for VSAM 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:
•General. 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 you select a connection, you can click Advanced Options to configure the optional advanced properties. For more information about these advanced properties, see VSAM source properties in mappings.
Note: If the mapping uses a specific source connection, you can specify these advanced 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 are parameterizing a source table, select the tables that correspond to the groups you selected in the mapping from the mapping task Sources tab. The number of tables you select must match the number of groups that were added in the multi group data object parameter. To select the source tables, click Select.
Note: To parameterize a source table, you must define a parameter of the type multi group data object for the mapping.
By default, the tables are associated with the groups in the order in which the tables appear in the table selection window. From the Group Map area, you can change the group to table association by using drag and drop to associate a group with a table.
When you finish entering information on the Sources page, click Validate to validate your entries.
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.