Example 2.1a insert sinusoid values into table (event based) – SQL Statement (defined in file PI_SINUSOID_OUT.SQL) INSERT INTO T2_1a (PI_TIMESTAMP1, PI_VALUE, PI_STATUS) VALUES (?,?,?); Relevant PI Point Attributes Extended Descriptor Location1 Location2 Location3 Location4 Location5 P1=TS P2=VL P3=SS_I 1 0 0 0 0 Instrumenttag Point Type Source Point Tag Source PI_SINUSOID_OUT.SQL Float32 SINUSOID S RDBMS Table Design Table T2_1a PI_TIMESTAMPn PI_VALUE PI_STATUS Datetime Real Smallint (MS SQL Server) (MS SQL Server) (MS SQL Server) Date/Time Single Precision Whole Number (MS Access) (MS Access) (MS Access)
Example 2.1a – insert sinusoid values into table (event based) SQL Statement (defined in file PI_SINUSOID_OUT.SQL) INSERT INTO T2_1a (PI_TIMESTAMP1, PI_VALUE, PI_STATUS) VALUES (?,?,?); Relevant PI Point Attributes Extended Descriptor Location1 Location2 Location3 Location4 Location5 P1=TS P2=VL P3=SS_I 1 0 0 0 0 Instrumenttag Point Type Source Tag Point Source PI_SINUSOID_OUT.SQL Float32 SINUSOID S RDBMS Table Design Table T2_1a PI_TIMESTAMPn PI_VALUE PI_STATUS Datetime (MS SQL Server) Date/Time (MS Access) Real (MS SQL Server) Single Precision (MS Access) Smallint (MS SQL Server) Whole Number (MS Access)
PI_RDBMSPI_3.21.4.30.docx