The model schema of the CURVALUE table contains the columns NAME, INTVAL, FLOATVAL, and TIME.
Column Name
Description
NAME
Name of the tag (primary key)
INTVAL
Integer value
FLOATVAL
Floating point value
TIME
The time the data was collected
The IP to access this data will be called the CVA IP.
The example data source is modeled with a single table called CURVALUE. Actually, this data can be stored in any format and the real data source may have more information, but, in this example, only the information defined in CURVALUE is supported.
Once a model is defined, it must be configured in the schema database. Assume that an OpenAccess SDK data source example1 has been configured. The SQL commands to add the table CURVALUE definition using the Interactive SQL tool (ODBCISQL, JDBCISQL, or OLEDBISQL) are as follows:
isql> connect example1
isql> DROP TABLE SCHEMA.OAUSER.CURVALUE;
isql> CREATE TABLE SCHEMA.OAUSER.CURVALUE (NAME VARCHAR(32) UNIQUE NOT NULL, INTVAL INTEGER, FLOATVAL FLOAT,
TIME TIMESTAMP);
See Schema definition and management for information on usage and limitations of this approach and to see a more complex example.
Refer to OpenAccess SDK SQL Reference for the DDL command syntax.
