Update Table Via JDBC

Last updated
Save as PDF

Update Table Via JDBC

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

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'
  ```