Page History
...
Documentation
Job Documentation including the full list of arguments: https://www.sos-berlin.com/doc/JS7-JITL/SQLExecutorJob.xml
...
- 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. - The SQLExecutorJob can be used with a credential store to hold sensitive arguments. For use of the
credential_store_*
arguments see JS7 - Use of Credential Store with JITL Jobs.
...
- JS7 - JITL PLSQLJob
- JS7 - JITL SQLPLUSJob
- JS7 - Job Resources
- JS7 - Use of Credential Store with JITL Jobs
Overview
Content Tools