IBM® Informix® 12.10
STS_HasInterruptedSignal function
The STS_HasInterruptedSignal function indicates whether the object has an interrupted signal for a specified time range.
Syntax
STS_HasInterruptedSignal(
ts TimeSeries,
begin_time DATETIME YEAR TO FRACTION(5),
end_time DATETIME YEAR TO FRACTION(5))
returns Boolean- ts
- The time series value.
- begin_time
- The start of the time range. Can be NULL to indicate the first element in the time series.
- end_time
- The end of the time range. Can be NULL to indicate the last element in the time series.
Usage
Run the STS_HasInterruptedSignal function to find out whether an object has an interrupted signal for the entire time range. An interrupted signal condition means that the object has missing data and is in a different location.
Returns
t = The object has an interrupted signal for the time range.
f = The object does not have an interrupted signal for the time range.
An exception = An error.
Example
The following query returns whether any vehicles had an interrupted signal between the times of 2014-06-07 20:52:53.00000 and 2014-06-10 16:49:36.00000:
SELECT modid, STS_HasInterruptedSignal(ts_track,
'2014-06-07 20:52:53.00000', '2014-06-10 16:49:36.00000')
FROM t_vehicle;
modid (expression)
1001 t
1002 f
2 row(s) retrieved. Vehicle 1001 had an interrupted signal.