DatabaseCLIExecutor
Description
The DatabaseCLIExecutor can be implemented in your ant script to execute statements on the database. The script can be implemented in SQL or JavaScript.
Input parameters
| Parameter | Description |
|---|---|
host |
The host machine to open a SSH connection. |
port |
The port for the connection. Default: 22 |
username |
The username to open the SSH connection. |
password |
The user’s password. |
defaultLogLevel |
The default log level. Default: verbose |
command |
The command that should be executed. |
commandFile |
A file that includes the to be executed commands. |
remoteProfile |
Here you can set the remote profile. This is supported for Db2 LUW and PostgreSQL. |
statementCounter |
A counter for the executed statements. Default: 0 |
statementDelimiter |
This sets the delimiter. Default: ; |
databaseType |
Here you can set the database type. Default: DB2_LUW |
language |
This sets the language for your statements. It can be set to "JavaScript" or "SQL". Default: SQL |
addDefaultLogActions |
This option can add default actions. Default: true |