Example 3.5 Tag Distribution with Aliases in Column Names – SQL Statement (file PI_DIST3.SQL) SELECT NAME AS PI_TAGNAME, VALUE AS PI_VALUE , STATUS AS PI_STATUS, DATE_TIME AS PI_TIMESTAMP FROM T3_5 WHERE NAME LIKE ?; Relevant PI Point Attributes Extended Location1 Location2 Location3 Location4 Location5 Descriptor All points All points All points All points Distributor 1 Not -1 1 0 – P1="Key_123%" evaluated Not Target points - evaluated /ALIAS='value retrieved from NAME column' Instrumenttag Point Type Point Source (Distributor) S PI_DIST3.SQL Float32 RDBMS Table Design Table T3_5 DATE_TIME NAME VALUE STATUS Datetime Char(80) Real Real (MS SQL Server) (MS SQL Server) (MS SQL Server) (MS SQL Server) Date/Time Text(80) Text(255) Text(12) (MS Access) (MS Access) (MS Access) (MS Access)
Example 3.5 – Tag Distribution with Aliases in Column Names SQL Statement (file PI_DIST3.SQL) SELECT NAME AS PI_TAGNAME, VALUE AS PI_VALUE , STATUS AS PI_STATUS, DATE_TIME AS PI_TIMESTAMP FROM T3_5 WHERE NAME LIKE ?; Relevant PI Point Attributes Extended Descriptor Location1 All points Location2 All points Location3 Location4 All points Location5 All points Distributor – P1="Key_123%" Target points - /ALIAS='value retrieved from NAME column' 1 Not evaluated -1 Not evaluated 1 0 Instrumenttag Point Type (Distributor) Point Source S PI_DIST3.SQL Float32 RDBMS Table Design Table T3_5 DATE_TIME NAME VALUE STATUS Datetime (MS SQL Server) Date/Time (MS Access) Char(80) (MS SQL Server) Text(80) (MS Access) Real (MS SQL Server) Text(255) (MS Access) Real (MS SQL Server) Text(12) (MS Access)
PI_RDBMSPI_3.21.4.30.docx