Relational Database(rdbms via odbc) Interface

Example 5.2a – Batch Export (Module Database required)

SQL Statement (file PI_BA2a.SQL)
INSERT INTO T5_2a (BA_START, BA_END, BA_ID, BA_PRODUCT, BA_RECIPE, BA_GUID) VALUES (?, ?, ?, ?, ?, ?);
Relevant PI Point Attributes
Extended Descriptor	Location1	Location2		Location3	Location4	Location5
/BA.START="*-10d" P1=BA.START P2=BA.END P3=BA.ID P4=BA.PRODID P5=BA.RECID P6=BA.GUID	1	0		0	1	0
Point Type	InstrumentTag	Point Source
Float32	PI_BA2a.SQL	S
RDBMS Table Design
Table T5_2a
BA_ID BA_PRODUCT BA_RECIPE BA_GUID			BA_START BA_END
Varchar(1024) (MS SQL Server) Text(255) (MS Access)			Datetime (MS SQL Server) Date/Time (MS Access)

Example 5.2b – UnitBatch Export (Module Database required)

SQL Statement (file PI_BA2b.SQL)
INSERT INTO T5_2b (UB_START,UB_END, UB_ID, UB_PRODUCT,UB_PROCEDURE,BA_GUID,UB_GUID) VALUES (?,?,?,?,?,?,?);
Relevant PI Point Attributes
Extended Descriptor	Location1	Location3		Location4	Location5
/UB.START="*-10d" /SB_TAG="SBTag" P1=UB.START P2=UB.END P3=UB.ID P4=UB.PRODID P5=UB.PROCID P6=BA.GUID P7=UB.GUID	1	0		1	0
Point Type	InstrumentTag	Point Source
Float32	PI_BA2b.SQL	S
RDBMS Table Design
Table T5_2b
UB_ID UB_PRODUCT UB_PROCEDURE UB_GUID BA_GUID			UB_START UB_END
Varchar(1024) (MS SQL Server) Text(255) (MS Access)			Datetime (MS SQL Server) Date/Time (MS Access)

Example 5.2c – SubBatch Export (Module Database required)

SQL Statement (file PI_BA2c.SQL)
INSERT INTO T5_2c (SB_START, SB_END, SB_ID, SB_HEAD, SB_GUID, UB_GUID) VALUES (?, ?, ?, ?, ?, ?);
Relevant PI Point Attributes
Extended Descriptor	Location1	Location3		Location4	Location5
P1=SB.START P2=SB.END P3=SB.ID P4=SB.HEADID P5=SB.GUID P6=UB.GUID	1	0		1	0
Point Type	InstrumentTag	Point Source
Float32	PI_BA2c.SQL	S
RDBMS Table Design
Table T5_2c
SB_ID SB_HEAD SB_GUID UB_GUID			SB_START SB_END
Varchar(1024) (MS SQL Server) Text(255) (MS Access)			Datetime (MS SQL Server) Date/Time (MS Access)