TD_TRACKINGOP Syntax Elements - Teradata Vantage

Teradata® VantageCloud Lake
Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
ft:locale
en-US
ft:lastEdition
2024-12-11
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905
SERIES_SPEC
The time series passed to the function. The first three fields of the PAYLOAD fields must be as follows:
  • Field 1: A column or field which is a timestamp or timestamp with time zone data type. The field represents the arrival time associated with the object being tracked.
  • Field 2: A column or field which is a timestamp or timestamp with time zone data type. The field represents the departure time associated with the object being tracked.
  • Field 3: A column or field which is a geospatial data type that represents the location of the object being tracked.

Any number of fields may follow the first three fields, and can be any non-LOB data type.

See Series Specifications.

FUNC_PARAMS
Name Data Type Description
DISTANCE Integer Indicator to calculate the track distance. A value of 1 means to calculate. A value of 0 means do not calculate. Default value is 0.
SPEED Integer Indicator to calculate the average speed with maximum and minimum values. A value of 1 means to calculate. A value of 0 means do not calculate. Default value is 0.
TIME_SPENT Integer Indicator to calculate the total time for the trip. A value of 1 means to calculate. A value of 0 means do not calculate. Default value is 0.
METRIC Integer Indicator to use metric distance and time. A value of 1 means to use kilometers. A value of 0 means to use miles. Default value is 0.
INPUT_FMT
No INPUT_FMT options are available for this function.
OUTPUT_FMT
No OUTPUT_FMT options are available for this function.