Page History
...
Users want to execute Stored Procedures in an SQL Server® database and
- return results as variables for subsequent jobs in a workflow,
- extract results to files in CSV, JSON or XML format.
...
The connection to a SQL Server® database includes to specify
...
- The job is assigned a Job Resource that holds a variable that indicates a Hibernate configuration file with access data and credentials for the SQL Server® database, see JS7 - Job Resources.
...
The command
argument holds the SQL query statement that looks like this:
- Basically a stored procedure is created and is executed that returns a result set.
- Consider use of semicolons in SQL statements that enclose a number of statements that are executed as a batch. This corresponds to the SQL Server®
GO
statement. - Consider use of the
${securityLevel}
workflow variable that is used to parameterize the call to the stored procedure.
...
- The job is assigned a Job Resource that holds a variable that indicates a Hibernate configuration file with access data and credentials for the SQL Server® database, see JS7 - Job Resources.
...
- Basically a stored procedure is created and is executed.
- Consider use of semicolons in SQL statements that enclose a number of statements that are executed as a batch. This corresponds to the SQL Server®
GO
statement. - Consider use of the
${securityLevel}
workflow variable that is used to parameterize the call to the stored procedure.
...
Overview
Content Tools