Page History
...
- return results as variables for subsequent jobs in a workflow,
- extract results to a file files in CSV, JSON or XML format.
Prerequisites
The connection to a SQL Server database includes to specify
...
- Download workflow example (upload .json): dbSQLServerSQLExecutionStoredProcedureResultAsVariables.workflow.json
- Users should consider to adjust Agent assignment to jobs to their environment.
- Included shell jobs are available for Windows, users find examples for Unix environments from the below chapters.
The example makes use of
...
- The script displays the values of environment variables to which return variables have been mapped.
- The script for a Unix Windows environment looks like this:
The same script used for a Windows Unix environment will look like this:
Log Output of Order Execution
...
- Download workflow example (upload .json): dbSQLServerSQLExecutionStoredProcedureExtractCSV.workflow.json
- Users should consider to adjust Agent assignment to jobs to their environment.
- Included shell jobs are available for Windows, users find examples for Unix environments from the below chapters.
The example makes use of
...
resultset_as_variables
: the valuecsv
specifies that a result file will be created in CSV format. The location of the result CSV file is specified from theresult_file
workflow variable.- Specifying the value
xml
will create a result file in XML format. - Specifying the value
json
will create a result file in JSON format.
- Specifying the value
exec_returns_resultset
: the valuetrue
specifies that the stored procedure is expected to return a result set.
...
- The script writes the contents of the resulting CSV file to the stdout channel.
- The script for a Unix Windows environment looks like this:
The same similar script used for a Windows Unix environment will look like this:
Log Output of Order Execution
...
Overview
Content Tools