Home
Extending 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 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™.
extensions and modulesThese topics describe how to use built-in database extensions and separately installed 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
InstanceId functionThe InstanceId function determines if the time series is stored in a container and, if it is, returns the instance ID of that time series.

InstanceId function

The InstanceId function determines if the time series is stored in a container and, if it is, returns the instance ID of that time series.

Syntax

InstanceId(ts TimeSeries) 
returns integer;

InstanceId(ts TimeSeries) 
returns bigint;

ts: The source time series.

Description

The instance ID is used as an index in the container. It can also be used to lookup information from the TSInstanceTable table.

Returns

The instance ID associated with the specified time series, unless the time series is stored in a row rather than in a container, in which case the return value is -1.

Example

The following example gets the instance IDs for each stock in the activity_stocks table:

select stock_id, InstanceId(activity_data) from activity_stocks;