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™.
Create and manage a time series through SQLBefore you can load time series data into the database, you must configure database objects specific to your time series. You can manage data storage and remove data as necessary. You can run SQL statements to create and manage time series.
Load data into a time seriesYou can use several methods to load data into the time series. Some methods require you to create the time series instance before you load data.
Load data with the BulkLoad functionYou can load data into an existing time series with the BulkLoad function. This SQL function takes an existing time series and a file name as arguments. The file name is for a file on the client that contains row type data to be loaded into the time series.

Load data with the BulkLoad function

You can load data into an existing time series with the BulkLoad function. This SQL function takes an existing time series and a file name as arguments. The file name is for a file on the client that contains row type data to be loaded into the time series.

The syntax for using BulkLoad with the UPDATE statement and the SET clause is:

update table_name
   set TimeSeries_col=BulkLoad(TimeSeries_col, 'filename')
   where col1='value';

The TimeSeries_col parameter is the name of the column that contains the row type. The filename parameter is the name of the data file. The WHERE clause specifies which row in the table to update.