Example 3.9 Stored Procedure Call – SQL Statement {CALL SP_T3_9(?,?)}; Stored procedure definition CREATE PROCEDURE SP3_9 @Start_Time DateTime, @End_Time DateTime AS SELECT PI_TIMESTAMP,PI_VALUE,PI_STATUS FROM T3_9 WHERE PI_TIMESTAMP BETWEEN @Start_Time AND @End_Time Relevant PI Point Attributes Extended Descriptor Location1 Location2 Location3 Location4 Location5 /SQL= 1 1 0 1 0 "{CALL SP3_9(?,?)};" P1=LST P2=ST InstrumentTag Point Point Type Source Float16 S RDBMS Table Design Table T3_9 PI_TIMESTAMP PI_VALUE PI_STATUS Datetime Real Smallint (MS SQL Server) (MS SQL Server) (MS SQL Server)
Example 3.9 – Stored Procedure Call SQL Statement {CALL SP_T3_9(?,?)}; Stored procedure definition CREATE PROCEDURE SP3_9 @Start_Time DateTime, @End_Time DateTime AS SELECT PI_TIMESTAMP,PI_VALUE,PI_STATUS FROM T3_9 WHERE PI_TIMESTAMP BETWEEN @Start_Time AND @End_Time Relevant PI Point Attributes Extended Descriptor Location1 Location2 Location3 Location4 Location5 /SQL= "{CALL SP3_9(?,?)};" P1=LST P2=ST 1 1 0 1 0 InstrumentTag Point Type Point Source Float16 S RDBMS Table Design Table T3_9 PI_TIMESTAMP PI_VALUE PI_STATUS Datetime (MS SQL Server) Real (MS SQL Server) Smallint (MS SQL Server)
PI_RDBMSPI_3.21.4.30.docx