TSL_ActiveHandles function

The TSL_ActiveHandles function returns the handles for active loader sessions.

Syntax

TSL_ActiveHandles()
returns SET(LVARCHAR NOT NULL)

Usage

Run the TSL_ActiveHandles function to get a list of active loader sessions that were initialized by the TSL_Init function.

Returns

A SET data type with one or more handles for active loader sessions. Each handle consists of a table name and a TimeSeries column name.

NULL if no loader sessions are active.

Example

The following statement returns the handles for active loader sessions:

EXECUTE FUNCTION TSL_ActiveHandles();

      SET{'iot_device_table|ts_data','meter_data|readings'}

Two loader sessions are active: one for the iot_device_table table and ts_data column, and one for the meter_data table and readings column.

The following statement returns the handles in table format:

SELECT * FROM TABLE(tsl_activehandles()) AS t(al)

al      iot_device_table|ts_data

al      meter_data|readings