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™.
Time series SQL routines
FindHidden functionThe FindHidden function scans a time series and returns all elements that are hidden.

FindHidden function

The FindHidden function scans a time series and returns all elements that are hidden.

Syntax

FindHidden(ts TimeSeries, 
       start datetime year to fraction(5) default NULL, 
       end   datetime year to fraction(5) default NULL) 
returns multiset;

ts: The time series to act on.
start (optional): The date from which to start the scan.
end (optional): The date at which to end the scan.

Description

You can scan the whole time series or specify a start date and an end date for the scan.

Returns

A multiset containing all the hidden elements in the date range you specify.