DB2 Loader Connector > Mappings and mapping tasks with DB2 Loader Connector > DB2 Loader targets in mappings
  

DB2 Loader targets in mappings

To write data to a DB2 database, configure a DB2 Loader object as the target in a mapping.
Specify the name and description of the DB2 target. Configure the target and advanced properties for the target object.
The following table describes the target properties that you can configure for a DB2 Loader target:
Property
Description
Connection
Name of the target connection.
You can select an existing connection, create a new connection, or define parameter values for the target connection property.
To overwrite the target connection properties at runtime, select the Allow parameter to be overridden at run time option.
Target Type
Type of the DB2 Loader target object.
Select one the following target types:
  • - Single
  • - Parameter
Object
Name of the DB2 Loader target object.
Specify the target object that you want to create. You can also select an existing object from the list.
Parameter
A parameter file where you define values that you want to update without having to edit the task.
Select an existing parameter for the target object or click New Parameter to define a new parameter for the target object.
The Parameter property appears only if you select parameter as the target type.
If you want to overwrite the target object at runtime, select the Allow parameter to be overridden at run time option. When the task runs, the agent uses the parameters from the file that you specify in the advanced session properties.
Operation
Type of the target operation.
You can perform only the insert operation on a DB2 Loader target.
The following table describes the advanced target properties that you can configure for a DB2 Loader target:
Property
Description
Append if exists
Appends the output data to the target files and reject files.
Default is disabled.
Create Target Directory
Creates a directory to store the output files.
Default is disabled. Do not change the default value.
Header Options
The header row in the DB2 Loader target table.
Select one of the following header options from the list:
  • - No Header. Does not create a header row in the target table.
  • - Output Field Names. Creates a header row in the target table with the output field names.
  • - Use header command output. Not applicable.
Default is No Header.
Output File Directory
The directory that stores the output files.
Specify the directory where you want to store the output files.
Ensure that the specified directory is accessible from the Secure Agent machine.
Default is $PMTargetFileDir.
Note: Do not use double spaces in the directory name of the output file.
Output File Name
Creates the output file in the output file directory with the name you specify.
Specify the output file name.
To write to multiple target tables, enter a unique output file name for each target.
Default is output1.out.
Reject File Directory
The directory that stores the rejected files.
Specify the directory where you want to store the rejected files.
Default is $PMBadFileDir.
Reject File Name
Creates the rejected file in the reject file directory with the name you specify.
Specify the reject file name.
Default is Output1.bad.
File Delimiter
The delimiter to use to separate columns of data in a delimited flat file.
Default is comma (,). Do not change the default value.
Table Name Prefix
Prefix that the Secure Agent adds to the target table name.
Enter a schema name to add as a prefix to the table name that you load to the target.
When you add a prefix in this field, the target table name appears in the control file in the following format:
<table name prefix>.table name
Target Table Name
The target table name that you want to override in a mapping.
Code Page
The code page that the Secure Agent uses to write data to a delimited flat file.
Select one of the following code pages from the list:
  • - MS Windows Latin 1 (ANSI), superset of Latin 1
  • - Unicode Transformation Format, multibyte
Default is MS Windows Latin 1 (ANSI), superset of Latin 1.
Optional Quotes
Quote characters that define the boundaries of data in a delimited flat file.
Select one of the following quotes from the list:
  • - None
  • - Single
  • - Double
Default is None.
Forward Rejected Rows
Determines whether the transformation passes rejected rows to the next transformation or drops rejected rows. By default, the mapping task forwards rejected rows to the next transformation.
If you select the Forward Rejected Rows option, the Secure Agent flags the rows for reject and writes them to the reject file.
If you do not select the Forward Rejected Rows option, the Secure Agent drops the rejected rows and writes them to the session log file. The Secure Agent does not write the rejected rows to the reject file.