IBM® Informix® 12.10
STS_SubtrackAlterLagToCurrent function
The STS_SubtrackAlterLagToCurrent function changes the indexing lag time.
Syntax
STS_SubtrackAlterLagToCurrent(
subtrack_name VARCHAR(128),
ts_data_lag_to_current INTERVAL DAY TO SECOND DEFAULT NULL)
returns INTEGER- subtrack_name
- The name of the subtrack table.
- ts_data_lag_to_current
- The indexing lag time. The time interval before the current time to avoid indexing. Default is the time stamp of the latest element in the time series.
Usage
Run the STS_SubtrackAlterLagToCurrent function to change the value of the ts_data_lag_to_current parameter, as set by the STS_SubtrackCreate function. The change in indexing lag time takes effect when new data is loaded and indexed.
Returns
0 = The indexing lag time is changed.
An exception = An error.
Example
The following statement changes the indexing lag time to one hour:
EXECUTE FUNCTION STS_SubtrackAlterLagToCurrent(
't_vehicle_subtrack',
'0 01:00:00'::INTERVAL DAY TO SECOND);