Example 3.8 Multi Statement Query – SQL Statement (file PI_MULTI.SQL) INSERT INTO T3_8 (PI_TIMESTAMP, PI_VALUE, PI_STATUS) VALUES (?, ?, ?); DELETE FROM T3_8 WHERE PI_TIMESTAMP < ?; Relevant PI Point Attributes Extended Location1 Location2 Location3 Location4 Location5 Descriptor P1=TS 1 0 0 0 0 P2=VL P3=SS_I P4=TS InstrumentTag Point Type Source Tag Point Source PI_MULTI.SQL Float32 SINUSOID S RDBMS Table Design Table T3_8 PI_TIMESTAMP PI_VALUE PI_STATUS Datetime SmallInt Smallint (MS SQL Server) (MS SQL Server) (MS SQL Server) Date/Time Number-Whole Number Number Single Precision (MS Access) (MS Access) (MS Access)
Example 3.8 – Multi Statement Query SQL Statement (file PI_MULTI.SQL) INSERT INTO T3_8 (PI_TIMESTAMP, PI_VALUE, PI_STATUS) VALUES (?, ?, ?); DELETE FROM T3_8 WHERE PI_TIMESTAMP < ?; Relevant PI Point Attributes Extended Descriptor Location1 Location2 Location3 Location4 Location5 P1=TS P2=VL P3=SS_I P4=TS 1 0 0 0 0 InstrumentTag Point Type Source Tag Point Source PI_MULTI.SQL Float32 SINUSOID S RDBMS Table Design Table T3_8 PI_TIMESTAMP PI_VALUE PI_STATUS Datetime (MS SQL Server) Date/Time (MS Access) SmallInt (MS SQL Server) Number-Whole Number (MS Access) Smallint (MS SQL Server) Number Single Precision (MS Access)
PI_RDBMSPI_3.21.4.30.docx