Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • to specify the JITL job class and com.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

...