Page History

hibernate_configuration_file

Specifies the configuration file (XML) format for Hibernate connections, see JS7 - Database. By default Agents ship without hibernate configuration files. However, if a file with the default name is available then it will be applied.

resultset_as_warning

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

exec_returns_resultset

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

resultset_as_variables

Specifies how a result set is forwarded to order variables for subsequent jobs:

• false: no result set is processed (default)
• column_value: for the first record of the result set from each column name a variable is created that holds the column value.
• name_value:  the first two columns of the result set will be added to order variables. The values of the first column of each record included with the result set will become the variable names, the values of the second column will become the variable values. 
• csv: the column names will be written to the first line of the file specified with the result_file argument, any column values of the result set will be written to subsequent lines of this file. Column names and values will be enclosed with double quotes and will be separated by commas.
  • Example:
  • "FIRST_NAME","LAST_NAME","AGE"
"John","Doe","30"

• xml: rows are created as a sequence of <ROW> elements of the <RESULTSET> root element. The column names will be created as XML element names. XML output is written to the file specified with the result_file argument. 
  • Example:

  • <?xml version="1.0" encoding="UTF-8"?>
<RESULTSET>
  <ROW>
    <FIRST_NAME><![CDATA[John]]></FIRST_NAME>
    <LAST_NAME><![CDATA[Doe]]></LAST_NAME>
    <AGE><![CDATA[30]]></AGE>
  </ROW>
</RESULTSET>

  • json: the column names will be written as an array of JSON objects to the file specified with the result_file argument, any column values of the result set will be written as object properties to this file. 
    • Example:

    • [
  {
    "FIRST_NAME" : "John",
    "LAST_NAME" : "DOE",
    "AGE" : 30
  }
]