JS7 JobScheduler

Space shortcuts

Page tree

Versions Compared

Old Version 4

changes.mady.by.user Andreas Püschel

Saved on

compared with

New Version 5

changes.mady.by.user Andreas Püschel

Saved on

Key

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

...

The SOSSQLExecutor job accepts the following arguments:


NameRequiredDefault ValuePurpose
commandyes
Carries the SQL statements.

hibernate_configuration_file

no./config/hibernate.cfg.xml

Specifies the configuration file (XML) format for Hibernate connections, see JS7 - Database

.

command

yesCarries the SQL statements

.

resultset_as_warning

no

Raises a warning if the SQL statement creates a result set.

exec_returns_resultset

no

If stored procedures are called that return a result set then this argument has to be set to true in order to run the stored procedure as a query.

resultset_as_variables

no

Specifies if and how a result set is forwarded to order variables:

  • false: no result set is processed.
  • column_name: for the first record of the result set from each column a variable is created from the column name and value.
  • name_value:  the first two columns of the result set will be added to order variables. The values of the first column will become the variable names, the values of the second column will become the variable values. 



In the above configuration the resultset_as_warning parameter is set to true to ensure that the result is written to the log file. The log file would then appear as shown in the following listing

...