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 API routinesThe time series application programming interface routines allow application programmers to directly access a time series datum.
The ts_nth_elem() function

The ts_nth_elem() function

The ts_nth_elem() function returns the element at the nth position of the given time series.

Syntax

ts_tselem  
ts_nth_elem(ts_tsdesc  *tsdesc, 
             mi_integer N, 
             mi_integer *STATUS)

tsdesc: The descriptor returned by ts_open().
N: The time series offset or position to read the element from. This value must not be less than 0.
STATUS: A pointer to an mi_integer value that is set on return to indicate whether the element is NULL. See The ts_hide_elem() function for a description of STATUS.

Description

The equivalent SQL function is GetNthElem.

Returns

The element at the nth position of the given time series, and whether it was NULL. This value must not be freed by the caller. It is overwritten after two fetch calls.