Description
?You can use the SQL job entry to execute an a SQL script. This means a number of SQL statements separated by. (Separated by what?)
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 kettle variables to be used in the SQL Script. |
SQL script | The SQL script to execute. Multiple statements can be separated by semicolons. |