Example 1.6 Single Input with PI Annotations – SQL Statement (file PI_ANNO1.SQL) SELECT time AS PI_TIMESTAMP, value AS PI_VALUE, annotation AS PI_ANNOTATION FROM T1_6 WHERE time > ? ORDER BY time; Relevant PI Point Attributes Extended Location1 Location2 Location3 Location4 Location5 Descriptor P1=TS 1 1 0 1 1 Instrumenttag Point Type Point Source PI_ANNO1.SQL Float32 S RDBMS Table Design T1_6 TIME VALUE ANNOTATION Datetime Real Varchar(255) MS SQL Server) (MS SQL Server) (MS SQL Server) Date/Time Number-Single Precision Text(50) (MS Access) (MS Access) (MS Access)
Example 1.6 – Single Input with PI Annotations SQL Statement (file PI_ANNO1.SQL) SELECT time AS PI_TIMESTAMP, value AS PI_VALUE, annotation AS PI_ANNOTATION FROM T1_6 WHERE time > ? ORDER BY time; Relevant PI Point Attributes Extended Descriptor Location1 Location2 Location3 Location4 Location5 P1=TS 1 1 0 1 1 Instrumenttag Point Type Point Source PI_ANNO1.SQL Float32 S RDBMS Table Design T1_6 TIME VALUE ANNOTATION Datetime MS SQL Server) Date/Time (MS Access) Real (MS SQL Server) Number-Single Precision (MS Access) Varchar(255) (MS SQL Server) Text(50) (MS Access)