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.
  
  

...