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
ElemIsNull functionThe ElemIsNull function determines if an element contains no data.

ElemIsNull function

The ElemIsNull function determines if an element contains no data.

Syntax

ElemIsNull(ts     TimeSeries, 
           offset integer) 
returns Boolean;

ElemIsNull(ts     TimeSeries, 
           tstamp datetime year to fraction(5)) 
returns Boolean;

ts: The time series to act on.
offset: The offset of the element to examine.
tstamp: The time stamp of the element to examine.

Description

Use either offset or time stamp to locate the element you want to examine.

Returns

Returns TRUE if the element has never been written to or was written to and the data has since been deleted; returns FALSE if the element contains data or is hidden.