DBUpdate

Introduction

The DBUpdate task is designed to execute a write query on a specific database. This task allows you to perform database operations such as updating records, inserting new data, or modifying existing data.

By providing the necessary query, the DBUpdate task interacts with the specified database to carry out the requested write operation. This task is instrumental in maintaining and manipulating data within the database as part of the overall process flow.

Configuration

• Connector - Database connector that will be used in the task.
• Name - The display name of the task.
• Query - Database query that will be executed.
• Log on complete - Prints the response in the business log.
• Response - resultSet deserialized into a list of DBResponse object. DBResponse contains the list of the GenericRow objects.

For example, if a process variable res is used to catch the result from the DBUpdate task, to access it, use the following:

es.rows[0].column["updateCount"].value

In this case the result is contained within a single row and a single column named updateCount.

Example