TSL_GetKeyContainer function

The TSL_GetKeyContainer function returns the name of the container that stores the time series values for the specified primary key value.

Syntax

TSL_GetKeyContainer(
           handle       lvarchar,
           key_value    lvarchar)
returns varchar(128)
handle
The table and column name combination returned by the TSL_Attach or the TSL_Init function.
key_value
The primary key value. If the primary key contains multiple columns, separate each value by a pipe character.

Usage

Use the TSL_GetKeyContainer function to determine into which container the specified data is loaded. If you load data in multiple sessions, you can configure the sessions to load into different containers. You must run the TSL_GetKeyContainer function in the context of a loader session that was initialized by the TSL_Init function.

Returns

The name of the container.

Examples

The following statement returns the name of the container associated with the time series data for the primary key value of 1 in the meter table:

EXECUTE FUNCTION TSL_GetKeyContainer('meter|readings', '1');