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)
Example 3.6 – RxC Distribution
SQL Statement
(file PI_DIST4.SQL)
SELECT sampletime AS PI_TIMESTAMP1, name1 AS PI_TAGNAME1, value1 AS PI_VALUE1, sampletime AS PI_TIMESTAMP2, name2 AS PI_TAGNAME2, value2 AS PI_VALUE2, status2 AS PI_STATUS2, sampletime AS PI_TIMESTAMP3,name3 AS PI_TAGNAME3, value3 AS PI_VALUE3, status3 AS PI_STATUS3 FROM T3_6 WHERE sampletime > ?;
Relevant PI Point Attributes
Extended Descriptor
Location1
All points
Location2
All points
Location3
Location4
All points
Location5
All points
RxC Distributor: P1=TS
Targets:
1
Not evaluated
-2
Not evaluated
1
0
InstrumentTag
Point Type
(Distributor)
Point Source
S
PI_DIST4.
SQL
Float32
RDBMS Table Design
Table T3_6
SAMPLETIME
NAMEn
VALUEn
STATUSn
Datetime (MS SQL Server)
Date/Time (MS Access)
Char(80) (MS SQL Server)
Text(80) (MS Access)
Real (MS SQL Server)
Number (MS Access)
Real (MS SQL Server)
Number (MS Access)
Example 3.6b – RxC Distribution Using PI_TIMESTAMP Keyword
SQL Statement
(file PI_DIST4.SQL)
SELECT sampletime AS PI_TIMESTAMP, name1 AS PI_TAGNAME1, value1 AS PI_VALUE1, name2 AS PI_TAGNAME2, value2 AS PI_VALUE2, status2 AS PI_STATUS2, name3 AS PI_TAGNAME3, value3 AS PI_VALUE3, status3 AS PI_STATUS3 FROM T3_6b WHERE sampletime > ?;
