To specify a database table for contact logging
1.
In the process configuration dialog, select New Table or Database Table from the Export To or Log To drop-down list. This option usually appears at the bottom of the list, following the list of mapped tables.
The Specify Database Table window appears.
2.
Specify the table name.
*
You can use user variables in the table name. For example, if you specify MyTable<UserVar.a> as the table name, and the value of the user variable "a" is "ABC" at the time that the process is run, the output is written to a table named MyTableABC. You must set the Initial Value and the Current Value of the user variable before executing the flowchart.
3.
Select the database name from the drop-down list.
4.
Click OK.
The Specify Database Table window closes. You are returned to the process configuration dialog, and the Export/Log to field displays the name of the database table you entered.
5.
If a table of the name you specified exists, choose an option for writing the output data:
*
Append to Existing Data — if you choose this option, the existing table must have a schema compatible with the output data. In other words, field names and field types must match, and field sizes must allow for the output data to be written.
*
Replace All Records — if you choose this option, existing rows in the table are replaced with the new output rows.
Copyright IBM Corporation 2013. All Rights Reserved.