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.
Example: Load data with BulkLoad

Example: Load data with BulkLoad

The following example uses BulkLoad in the SET clause of an UPDATE statement to populate the existing time series in the daily_stocks table:

insert into daily_stocks values
   (999, 'HCLTECH', TSCreate ('daycal',
      '2011-01-03 00:00:00.00000',20,0,0, NULL));

update daily_stocks
   set stock_data=BulkLoad(stock_data,'sam.dat')
   where stock_name='HCLTECH';