Download ECHO OLE DB Data Provider User Guide

Catalogs and Tables
5-5
Part of
Can be Set
Column
Primary
to Null
Key
Name
WString
yes
yes
ServerFlushRate
Int32
no
no
ThrowAwayLimitPercentFull
Int32
no
no
ThrowAwayScanRate
Int32
no
no
ThrowAwayScanRatePercent
Int32
no
no
1 See ECHO SDK CHHistorian object property description for more details.
Data
Type
Comments 1
Sample SQL Statements
The following statement renames the historian.
UPDATE Historians SET Name = 'historian1' WHERE Descriptor = 'DB1'
NOTE: Renaming the Name column in the Historians table affects the
catalog names.
It is not possible to insert or delete rows in this table. See the "CREATE
DATABASE / DROP DATABASE Statements"section for more information on
this topic.
Metadata Table Structure
Data
Part of
Can be Set
Type
Primary Key to Null
Descriptor
WString no
no
Identity
WString yes
no
IDResolutionPluginIdleTimeout
Int32
no
yes
IDResolutionPluginIsRegistered
Bool
no
no
IDResolutionPluginProgID
WString no
yes
LogCHHistorianManualFlushEvents
Bool
no
no
LogCHHistorianPropertyModifyEvents
Bool
no
no
LogClientConnections
Bool
no
no
LogHistorianCreateEvents
Bool
no
no
LogHistorianDeleteEvents
Bool
no
no
LogPerfCounterResetEvents
Bool
no
no
LogPropertyModifyEvents
Bool
no
no
LoggingEnabled
Bool
no
no
Name
WString yes
no
ServerResponseTimeout
Int32
no
no
ServerTimeZone
WString no
no
1 See the ECHO SDK CHNode object property description for more details.
Column
Comments 1
Read only.
Read only.
Read only.
Read only.
Read only.