Product specifications
Accessing 800xA via OLE DB
3BDS011222-510 B 469
The name of the OLE DB provider is ABB OLE DB Provider for HT.
Command Line
The syntax for the command line is built up by a command followed by one or
several keywords as shown below.
Command Syntax. The command is GET_HISTORY, which has four syntaxes.
• GET_HISTORY(STORAGEINFO): You use the keyword STORAGEINFO to
get a list of all short references that exits in the Library Structure and are
related to history. No other keywords are allowed.
• GET_HISTORY(OBJECTHELPER=… ): You use the keyword
OBJECTHELPER to retrieve historical data according to one of the pre-
configured short references. No other keywords are allowed.
• GET_HISTORY(OBJECT=… ; ASPECT=… ; PROPERTY=… ; LOG=… ;
FROM=… ; TO=… ; “OTHER KEYWORDS”): You build a query by utilizing
a set of keywords that specify the historical log, the time frame and the amount
of data to retrieve. All the keywords given above are mandatory except for the
other keywords which are optional.
• GET_HISTORY(ITEMID=… ; FROM=… ; TO=… ;“OTHER
KEYWORDS”) If you already have the ITEMID string then it can be more
convenient for you to use this way of to give the command line. Also here all
keywords given are mandatory except for the “other keywords” which are
optional.
• GET_HISTORY(VERSION) You use the keyword VERSION to get version
information about the provider.
It is only possible to connect to the OLE DB Provider from the OLE DB Client
running on an 800xA client workstation.