Example 5.1 Batch Export (not requiring Module Database) – SQL Statement (file PI_BA1.SQL) INSERT INTO T5_1 (BA_ID,BA_UNITID,BA_PRODUCT,BA_START,BA_END) VALUES (?,?,?,?,?); Relevant PI Point Attributes Extended Location1 Location2 Location3 Location4 Location5 Descriptor P1=BA.BAID 1 0 0 1 0 P2=BA.UNIT P3=BA.PRID P4=BA.START P5=BA.END Point Type InstrumentTag Point Source Float32 PI_BA1.SQL S RDBMS Table Design Table T5_1 BA_ID BA_START BA_UNITID BA_END BA_PRODUCT Varchar(1024) Datetime (MS SQL Server) (MS SQL Server) Text(255) Date/Time (MS Access) (MS Access)
Example 5.1 – Batch Export (not requiring Module Database) SQL Statement (file PI_BA1.SQL) INSERT INTO T5_1 (BA_ID,BA_UNITID,BA_PRODUCT,BA_START,BA_END) VALUES (?,?,?,?,?); Relevant PI Point Attributes Extended Descriptor Location1 Location2 Location3 Location4 Location5 P1=BA.BAID P2=BA.UNIT P3=BA.PRID P4=BA.START P5=BA.END 1 0 0 1 0 Point Type InstrumentTag Point Source Float32 PI_BA1.SQL S RDBMS Table Design Table T5_1 BA_ID BA_UNITID BA_PRODUCT BA_START BA_END Varchar(1024) (MS SQL Server) Text(255) (MS Access) Datetime (MS SQL Server) Date/Time (MS Access)