...
| Setting | Description | |||||
|---|---|---|---|---|---|---|
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.
| |||||
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.1113.3.3 Tables and Stored Procedures. For further information about the stored procedure, see Database Forwarding Target Stored Procedure in 9.1113.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.1113.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.1113.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. |
...
The Assignment tab contains the assignment of values to each column or stored procedure parameter. The content and use of this tab is described further in Assignments in 9.1113.3.2 Configuration.
The Column Name column does not necessarily contain column names. If Stored Procedure is selected as the Access Type, this column will hold the names of all incoming parameters that the stored procedure expects.
...
All Value Types, described in Value Types in 9.1113.3.2 Configuration, except for To UDR, are available for selection.
...
| Setting | Description |
|---|---|
Commit Window Size | The number of UDRs (rows) to be inserted or removed between each database Rows are inserted for each UDR that is fed to the agent. All UDRs are stored in memory between each database |
General SQL Statement | In this area, the SQL statement that will be used to populate the database, is shown. This field may not be edited, however, it is useful for debug purposes or for pure interest. In order for the statement to appear, the Target and Assignment tabs have to be properly configured, or else information about the first detected missing or erroneous setting is displayed. |
| Scroll ignore | ||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||