SQLExecutor
Description
The SQLExecutor executes one or more SQL statements that are given inside an input file. The user must also define the database URL with a corresponding user and password.
Input parameters
| Parameter | Description |
|---|---|
url |
The database URL against which the SQL statements should be executed. |
user |
The database user. |
password |
The database user’s password. |
useEncryptedPassword |
Boolean if an encrypted database password should be used. |
databaseType |
The database type (DB2_LUW, …). |
inputFile |
The file containing the SQL statements to be executed. |
restartable |
Boolean to define if the specified statement(s) can be restarted. They will then be remembered and not executed again when the program is called again. |
commitFrequency |
Variable that defines after how many statements a commit should be done. Default is 50. |