"JDBC Update" Operation

This operation allows to execute an SQL Data Manipulation Language (DML) statement, such as INSERT, UPDATE or DELETE; or an SQL statement that returns nothing, such as a DDL statement.

General

Connection

This corresponds to the JDBC connection to use.

Parameter Definitions

This allows to manually define or (re)generate the query parameter list. Automated updating of this list can be enabled.

Statement

This corresponds to the text of the SQL command (which may be parameterized).

Input

This allows to specify the parameter values ​​for the statement.

(Operation Result)

affectedRowCount

The number of rows affected by the execution of the SQL command.