Details
-
Feature
-
Status: Released (View Workflow)
-
Minor
-
Resolution: Fixed
-
2.0.0
-
None
-
None
Description
Current Situation
- The SQLExecutorJob Template offers to export the result set of a database query to a file in CSV format.
Desired Behavior
- Export formats for database queries should include
- XML
- JSON
- The following JITL Job Templates should support the same functionality to export to CSV, XML and JSON files:
- PLSQLJob
Maintainer Note
- com.sos.jitl.jobs.db.SQLExecutorJob
- resultset_as_variables accepts additionally XML and JSON values (case insensitive).
- com.sos.jitl.jobs.db.oracle.PLSQLJob
- 2 new arguments introduced:
- resultset_as
- Default - empty. Possible values: CSV, XML or JSON (case insensitive).
- result_file
- The path to the output file that holds the result set in csv/xml/json format.
- resultset_as
- 2 new arguments introduced: