Home
Extending HCL OneDB™Beyond standard relational database objects, HCL OneDB™ can be extended to handle specialized data types, access methods, routines, and other objects. HCL OneDB™ includes many built-in extensions that are fully integrated in the database server. HCL OneDB™ also provides DataBlade® modules, which are packages of extended database objects for a particular purpose and that are installed separately from the database server. Alternatively, you can create your own user-defined objects for HCL OneDB™.
HCL OneDB™ extensions and DataBlade® modulesThese topics describe how to use built-in database extensions and separately installed DataBlade® modules.
TimeSeries Data User's GuideThe HCL OneDB™ TimeSeries Data User's Guide contains information to assist you in using the TimeSeries extension with HCL OneDB™.
Virtual tables for time series dataA virtual table provides a relational view of your time series data.
Creating a time series virtual tableYou can create a virtual table that is based on a time series or based on the results of an expression on a time series.

Creating a time series virtual table

You can create a virtual table that is based on a time series or based on the results of an expression on a time series.

About this task

You can update or insert data through a virtual table that is based on a time series table. You cannot update or insert data through a virtual table that is based on an expression on a time series.

Procedure

To create a virtual table that is based on a table that contains a TimeSeries column, run the TSCreateVirtualTab procedure.

Results

To create a virtual table that is based on the results of an expression that is performed on a time series, run the TSCreateExpressionVirtualTab procedure.

If you alter the base table, you must drop and re-create the virtual table.