Insert into Table Via JDBC
Use the Insert into Table via JDBC activity to insert values into a 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 inserts values into a table:
``` INSERT INTO mytable (column1,column2) VALUES ('val1','val2') ```