Page History
...
- to specify the
JITL
job class andcom.sos.jitl.jobs.db.SQLExecutorJob
Java class name, then add arguments as explained from the below documentation.
Example
Download: dbSQLExecutionConfigurationFile.json
A SQLExecutorJob configuration can look like this:
The job's arguments can be specified as follows:
...
- Note that it is possible to define more than one instruction with the
command
argument.
Such instructions are then carried out in the order in which they are written and must be separated by a semicolon.- Some DBMS might require an additional newline character.
- For example
update MY_TABLE set a='foo' where b='bar'; commit;
- Note that order variables and arguments can be injected to the SQL statement(s) of the
command
argument by use of the${variable}
syntax. - For use of the
credential_store_*
arguments see JS7 - Use of Credential Store with JITL Jobs.
Example
Download:
...
Further Resources
- Job Documentation:
- JS7 - Credential Store
...
Overview
Content Tools