- SERIES_SPEC (differenced_series) or ART_SPEC
- The primary input is a SERIES_SPEC or ART_SPEC that references an input source containing univariate or multivariate series instances. These series are differenced-series that were produced by a previous TD_DIFF invocation.The ART_SPEC is required to have the parameter TABLE_NAME. No other ART_SPEC parameters should be used.
ART_SPEC( TABLE_NAME( [database-name .] table-name ) )
- SERIES_SPEC (original, undifferenced series)
- [Dependencies: Not required if an INITIAL_VALUES list is provided, otherwise it is required.] This SERIES_SPEC references the original undifferenced series that was passed in the TD_DIFF call. This series is used to completely reconstruct the series.]
- FUNC_PARAMS
-
Name Data Type Description LAG Integer Value of the LAG parameter that was passed in during the TD_DIFF operation. It is zero or a positive integer. LAG, DIFFERENCES, and SEASONAL_MULTIPLIER collectively determine the differencing formula. DIFFERENCES Integer Value of the DIFFERENCES parameter that was passed in during the TD_DIFF operation. It is zero or a positive integer. LAG, DIFFERENCES, and SEASONAL_MULTIPLIER collectively determine the differencing formula. SEASONAL_MULTIPLIER Integer Value of the SEASONAL_MULTIPLIER parameter that was passed in during the TD_DIFF operation. The passed in value of 0 or 1 determines the formula that is applied in the differencing operation. It is zero or a positive integer. LAG, DIFFERENCES, and SEASONAL_MULTIPLIER collectively determine the differencing formula. . INITIAL_VALUES FLOAT The list represents the values used to provide starting values for the undifferencing operation. If the series was differenced with a lag of 1, then the INITIAL_VALUES list is required to have the first entry of the original undifferenced series. With a lag of 2, the INITIAL_VALUES list should have the first two entries of original series, and so on. If the series was differenced multiple times, then the INITIAL_VALUE list must have the same amount of original series values followed by the intermediate values.
- INPUT_FMT
- Mandatory specification. The INPUT_MODE parameter has the following options:
- ONE2ONE: Both the primary and secondary series specifications include a WHERE filter clause identifying one series instance to serve as the input series for the mathematical operation.
- MANY2ONE: The primary input SERIES_SPEC references MANY series instances. The secondary input SERIES_SPEC includes a WHERE filter clause identifying a single series instance. When applying the mathematical operation, the secondary input single series is reused as many times as necessary to match the number of series instances found in the primary input.
- MATCH: A series instance residing in the primary input whose SERIES_ID matches the SERIES_ID of a series instance in the secondary input, has the mathematical operation applied to produce a result series. For those instances in one input who have no corresponding SERIES_ID partner in the other input, the series is skipped over.
- OUTPUT_FMT
- No OUTPUT_FMT options are available for this function.