Stored procedures
- Last UpdatedAug 15, 2023
- 1 minute read
- PI System
- RtReports 5.0
- Visualization
If you have a stored procedure that can be used to generate a relational dataset, you can substitute the stored procedure for a SQL statement.
RtBaseline Services evaluates stored procedures and supports any parameter values required for processing.
To create a dataset from a stored procedure:
-
Add a relational dataset following the instructions up to entry of a SQL statement.
-
Instead of a SQL query, enter the name of the stored procedure in the SQL Statement field.
For example, enter CustOrderHist to execute a stored procedure from the Northwind database in SQL Server.
-
Click Verify SQL to test the stored procedure. A message box indicates whether the procedure executed correctly.
If parameters or placeholders are used in the procedure, they appear in the Place Holders section.
-
Configure placeholder information and provide text descriptions for dataset columns.
-
When finished, click Save to add the new dataset.