Example 1.4 Tag Distribution – SQL Statement (defined in file PI_REAL_DISTR1.SQL) SELECT PI_TIMESTAMP, PI_TAGNAME, PI_VALUE, PI_STATUS FROM T1_4 WHERE PI_TAGNAME LIKE 'Tag%' ORDER BY PI_TMESTAMP, PI_TAGNAME; Relevant PI Point Attributes Extended Location1 Location2 Location3 Location4 Location5 Descriptor (All points) (All points) All points All points (Distributor) 1 0 'Distributor' 1 0 -1 'Target_Point(n)' 0 Instrumenttag Point Type Point Source (Distributor) (Distributor) (All Points) Float32 S RDBMS Table Design Table T1_4 PI_TIMESTAMP PI_VALUE PI_STATUS PI_TAGNAME Datetime Real Varchar(12) Varchar(80) (MS SQL Server) MS SQL Server) (MS SQL Server) (MS SQL Server) Date/Time Number (Single) Text(12) Text(80) (MS Access) Prec.(MS Access) (MS Access) MS Access) Example of an appropriate result-set: PI_TIMESTAMP PI_TAGNAME PI_VALUE PI_STATUS 20-Oct-2000 08:10:00 Target_Point1 10 NULL 20-Oct-2000 08:10:00 Target_Point2 20 NULL 20-Oct-2000 08:10:00 Target_Point3 30 10 goes to Target_Point1; 20 to Target_Point1; 30 to Target_Point3 … Note: See also section:.
Example 1.4 – Tag Distribution SQL Statement (defined in file PI_REAL_DISTR1.SQL) SELECT PI_TIMESTAMP, PI_TAGNAME, PI_VALUE, PI_STATUS FROM T1_4 WHERE PI_TAGNAME LIKE 'Tag%' ORDER BY PI_TMESTAMP, PI_TAGNAME; Relevant PI Point Attributes Extended Descriptor (Distributor) Location1 (All points) Location2 (All points) Location3 Location4 All points Location5 All points 1 0 'Distributor' -1 'Target_Point(n)' 0 1 0 Instrumenttag (Distributor) Point Type (Distributor) Point Source (All Points) Float32 S RDBMS Table Design Table T1_4 PI_TIMESTAMP PI_VALUE PI_STATUS PI_TAGNAME Datetime (MS SQL Server) Date/Time (MS Access) Real MS SQL Server) Number (Single) Prec.(MS Access) Varchar(12) (MS SQL Server) Text(12) (MS Access) Varchar(80) (MS SQL Server) Text(80) MS Access) Example of an appropriate result-set: PI_TIMESTAMP PI_TAGNAME PI_VALUE PI_STATUS 20-Oct-2000 08:10:00 Target_Point1 10 NULL 20-Oct-2000 08:10:00 Target_Point2 20 NULL 20-Oct-2000 08:10:00 Target_Point3 30 10 goes to Target_Point1; 20 to Target_Point1; 30 to Target_Point3 … Note: See also section:.
PI_RDBMSPI_3.21.4.30.docx