Update Table Via JDBC

Use the Update Table via JDBC activity to update the columns in table by executing a SQL query.

Usage

Complete the following properties to use this activity:

• SQL - Specify the SQL query to be Executed or click the Variable Reference icon to choose a variable. For example, this query updates columns in a table:

                        ```
    UPDATE mytable set column1 = 'newvalue' where column2 = 'zzz'
    ```