Example 4 - Data Transfer From Oracle

This example shows the transfer of converted chromatograph data from Oracle. It also shows the use of relative addressing in the cross ref table.

Point Name - Daily Composition

Alias - DAILY_COMPOSITION

Residence = Ram

Categories = 00000000000000000000000000000001

CE Indicator = Enabled

CE Order = Natural

Attribute Name DE Type Value
device poll types rtBYTES4 (0x)00000004
device PRBX types rtBYTES4  
scan input control rtLOGICAL 1
scan input status rtUINT8  
failure threshold rtUINT8 3
scan input   (see below)
scan output control rtLOGICAL 0
scan output status rtUINT8  
scan output   (not used)
dev fail threshold rtUINT8 3
oracle table name rtBYTES48 "FDC_COMPS"
transfer direction rtUINT8 1
cross ref table   (see below)
debug level rtUINT8 0
sql filename rtBYTES32 ""
device stats rtUINT32  

point control poll type mask st buffer size # of elements RTAP DE type deadband type deadband rtap alias name
1 (0x)00000004 0 1 1 0 0 "M503"
1 (0x)00000004 0 1 1 0 0 "M504"
1 (0x)00000004 0 1 1 0 0 "M520"
1 (0x)00000004 0 1 1 0 0 "M658"

oracle field rtap attribute conv rtap de type
METER [alias] 0
N2 N2.converted value 0
CO2 CO2.converted value 0
C1 C1.converted value 0
C2 C2.converted value 0
C3 C3.converted value 0
IC4 IC4.converted value 0
NC4 NC4.converted value 0
IC5 IC5.converted value 0
NC5 NC5.converted value 0
C6 C6.converted value 0