RevealElem function

The RevealElem function makes an element at a specified time stamp available for a scan. It reverses the effect of HideElem.

Syntax

RevealElem(ts     TimeSeries, 
          tstamp datetime year to fraction(5)) 
returns TimeSeries;

RevealElem(ts        TimeSeries, 
          set_stamps multiset(datetime year to fraction(5))) 
returns TimeSeries;
ts
The time series to act on.
tstamp
The time stamp to be made visible to a scan.
set_stamps
The multiset of time stamps to be made visible to a scan.

Returns

The modified time series.

Example

The following example hides the element at 2011-01-03 in the IBM® time series and then reveals it:
select HideElem(stock_data, '2011-01-03 00:00:00.00000')
   from daily_stocks
   where stock_name = 'IBM';

select RevealElem(stock_data, '2011-01-03 00:00:00.00000')
   from daily_stocks
   where stock_name = 'IBM';