Example 3.4b Tag Distribution, Search According to Tag's ALIAS – Name SQL Statement (file PI_DIST2.SQL) SELECT TIME, PI_ALIAS, VALUE,0 FROM T3_4b WHERE TIME > ?; Relevant PI Point Attributes Instrument Extended Tag Location1 Location3 Location4 tag Descriptor Tag1 PI_DIST2.SQL P1=TS 1 -1 1 Tag2 /ALIAS=Valve1 1 1 Tag3 /ALIAS=Valve2 1 1 Tag4 /ALIAS=Valve3 1 1 RDBMS Table Data Table T3_4b Time PI_Alias Value 20-Oct-2000 08:10:00 Valve1 "Open" 20-Oct-2000 08:10:00 Valve2 "Closed" 20-Oct-2000 08:10:00 Valve3 "N/A"
Example 3.4b – Tag Distribution, Search According to Tag's ALIAS Name SQL Statement (file PI_DIST2.SQL) SELECT TIME, PI_ALIAS, VALUE,0 FROM T3_4b WHERE TIME > ?; Relevant PI Point Attributes Tag Instrument tag Extended Descriptor Location1 Location3 Location4 Tag1 PI_DIST2.SQL P1=TS 1 -1 1 Tag2 /ALIAS=Valve1 1 1 Tag3 /ALIAS=Valve2 1 1 Tag4 /ALIAS=Valve3 1 1 RDBMS Table Data Table T3_4b Time PI_Alias Value 20-Oct-2000 08:10:00 Valve1 "Open" 20-Oct-2000 08:10:00 Valve2 "Closed" 20-Oct-2000 08:10:00 Valve3 "N/A"
PI_RDBMSPI_3.21.4.30.docx