This example shows the updating of data to Oracle.
| Point Name - Tank_Volume
Alias - TANK_VOLUME Residence = Ram Categories = 00000000000000000000000000000001 CE Indicator = Enabled CE Order = Natural |
||
|---|---|---|
| Attribute Name | DE Type | Value |
| device poll types | rtBYTES4 | (0x)00000001 |
| 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 | "TANK_VOLUME" |
| transfer direction | rtUINT8 | 15 |
| 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)00000001 | 0 | 1 | 1 | 0 | 0 | "TANK 2 LEVEL" |
| 1 | (0x)00000001 | 0 | 1 | 1 | 0 | 0 | "TANK 3 LEVEL" |
| 1 | (0x)00000001 | 0 | 1 | 1 | 0 | 0 | "TANK 4 LEVEL" |
| 1 | (0x)00000001 | 0 | 1 | 1 | 0 | 0 | "TANK 5B LEVEL" |
| oracle field | rtap attribute | conv rtap de type |
|---|---|---|
| DATE_EFFECTIVE | .time stamp | 0 |
| LIQUID_VOLUME | .current value | 0 |
| CREATE_DATE_TIME | [time] | 31 |
| [sqlWhere] | [sqlWhere] | 0 |
| TANK_POINT | [alias] | 20 |