User Guide > Process Steps and Components > Invoker Step > WebRowSet Update Invoker
Was this helpful?
WebRowSet Update Invoker
The WebRowSet Update Invoker uses a WebRowSet as input and applies updates (INSERT, DELETE, or MODIFY) to a target database.
Supported Actions
Action
Description
Execute
Executes the supported parameters and properties.
Supported Action Parameters
Action
Parameter
Description
Execute
SourceMessage
Name of the source message for the invoker. The body of the message must contain the WebRowSet statement as the input for the update.
TargetMessage
Optional name of the target message for the invoker
If specified and the target supports BatchResponse, the BatchResponse is returned in the message body.
 
Supported Action Properties
Action
Property
Description
Execute
TargetType
Multimode target type.
Execute
TargetServer
Target server host name.
Execute
TargetDatabase
Database updated by the invoker.
Execute
TargetTable
Name of table where update is applied.
Execute
Username
User ID to access the target database. The connection is limited to the access rights of the user ID that you enter.
Execute
Password
Password to access the target database
Execute
UpdateKeys
Field names in the target table to use as the keys for the update. Required for MODIFY and DELETE.
If you specify multiple field names, use commas to separate them.
UpdateKeys are also known as ActionKeys.
Note:  Any property value you set in the source message overrides the invoker property value.
Last modified date: 02/01/2024