Example 2.1b insert sinusoid values into table (scan based) – SQL Statement (defined in file PI_SIN_OUT_SCAN.SQL) INSERT INTO T2_1b (PI_TIMESTAMP1, PI_VALUE, PI_STATUS) VALUES (?,?,?); Relevant PI Point Attributes Extended Descriptor Location1 Location2 Location3 Location4 Location5 P1='SINUSOID'/TS 1 0 0 1 0 P2='SINUSOID'/VL P3='SINUSOID'/SS_I Instrumenttag Point Type Source Point Tag Source PI_SIN_OUT_SCAN.SQL Float32 S RDBMS Table Design Table T2_1b 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.1b – insert sinusoid values into table (scan based) SQL Statement (defined in file PI_SIN_OUT_SCAN.SQL) INSERT INTO T2_1b (PI_TIMESTAMP1, PI_VALUE, PI_STATUS) VALUES (?,?,?); Relevant PI Point Attributes Extended Descriptor Location1 Location2 Location3 Location4 Location5 P1='SINUSOID'/TS P2='SINUSOID'/VL P3='SINUSOID'/SS_I 1 0 0 1 0 Instrumenttag Point Type Source Tag Point Source PI_SIN_OUT_SCAN.SQL Float32 S RDBMS Table Design Table T2_1b 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)