Description
You can use the SQL job entry to execute a SQL script.
Options
Option |
Description |
---|---|
Name of the job entry |
The name of the job entry. This name has to be unique in a single job. A job entry can be placed several times on the canvas, however it will be the same job entry. |
Database Connection |
The database connection to use. |
SQL from file |
Enable this option to load the SQL statement from a file given by the SQL filename |
SQL filename |
The filename for the file with SQL statements. |
Send SQL as single statement? |
Enable this option to not separate the statement by semicolons. This is often useful when a script is given or multiple statements should be processed and committed as one single statement. |
Use variable substitution? |
Enables variables to be used in the SQL Script. |
SQL script |
The SQL script to execute. Multiple statements can be separated by semicolons. |