UDR Type

Type of UDR to populate the target database table.

Database

Profile defining the database that the agent is supposed to connect and forward data to. The list is populated each time the configuration dialog is opened. For further information about database profile setup, see 8.6 Database Profile.

Use Default Database Schema

Select this check box to use the default database schema for the chosen database and user.

Access Type

Determines if the insertion of data is to be performed directly into the target table, or via a stored procedure.

• Direct - Insertion of data is performed directly.

• Stored Procedure - Insertion of data is performed via a stored procedure.

Table Name or SP Name

Depending on the selected Access Type, the target database table name, or the stored procedure name, is selected. The list is populated each time a new Database or Access Type is selected.

For further information and an example of a working table, see Working Table in 9.1213.3.3 Tables and Stored Procedures. For further information about the stored procedure, see Database Forwarding Target Stored Procedure in 9.1213.3.3 Tables and Stored Procedures.

Transaction ID Column

Name of the column in the selected table, or the parameter from the selected stored procedure, which is used for the Transaction ID Column. The list is populated each time a Table Name or SP Name is selected.

The column must be of the data type number, with at least twelve digits.

Cleanup SP

If the selected Access Typeis Stored Procedure, the agent does not automatically clean up the target table, in case of a workflow abortion (Cancel Batch). If that is the case, the customer must supply a stored procedure that manages the clean up.

For further information and an example of a Cleanup Stored Procedure, see Cleanup Stored Procedure in 9.1213.3.3 Tables and Stored Procedures.

SP Target Table

Name of the target table for the stored procedure. This field is only enabled if the >Access Type is Stored Procedure.

If this agent is chained with a Database collection agent in another workflow, both agents need to be aware of the mutual table. In the collection agent, a table to collect from is always selected. However, in the forwarding agent, it is possible to select the update of the table to be done via a stored procedure. If that is the case, the target table for the stored procedure must be selected here. For further information, see Pending Transaction Table in 9.1213.3.1 Inter-Workflow Communication, Using Database Agents.

Run SP

If enabled, this option causes a user defined stored procedure to be called when the forwarding process terminates. It will then receive the transaction ID for the forwarded rows as input.

This option is used for transaction safety when the table is read from another system, to ensure no temporary rows are read. Rows are classified as temporary until End Batch is reached. In case of a crash before End Batch is reached, the workflow needs to be restarted for the temporary rows to be expunged.