TD_​SINFO

The TD_SINFO 'Series Information' function is an AF Utility function used to return some metadata describing the logical series identified by the SERIES_SPEC specification passed into the function. For each series this function returns:. Series Index Data type - TIMESTAMP, TIMESTAMP WITH TIME ZONE, DATE, INTEGER, or FLOAT. Starting Index value associated with the series . Ending Index value associated with the series . Count of total number of entries in the series. Flag indicating whether this is a discrete/regular series or an irregular series. Sample interval - sample interval associated with a discrete series; or, alternatively, average of all sample intervals encountered, if it is an irregular series.. Content Type of payload “fields” - REAL, COMPLEX, AMPL_PHASE_RADIANS, AMPL_PHASE_DEGREES, MULTIVAR_REAL, MULTIVAR_COMPLEX, MULTIVAR_AMPL_PHASE_RADIANS, or MULTIVAR_AMPL_PHASE_DEGREES. For each payload “fields” :Minimum sample magnitude encountered in series,Maximum sample magnitude encountered in series,Average of all magnitudes encountered in series, Root-Mean-Square (RMS) for each magnitude in the series

Options

Output Schema
Output Schema, if Volatile is true then use user login as the schema.
Output Table
Output Table
VAL Location
VAL Location
Volatile
Specifies whether the table should be a VOLATILE table. If true, then the table is automatically deleted, otherwise it is users responsibility to remove or clean it up for space.

Input Ports

Icon
Connection to a Teradata Database Instance
Icon
This AF function is passed a collection of logical series described by a series specification SERIES_SPEC. These logical series can be of either the regular or irregular variety. Their indexing mechanisms can be based on time or space.

Output Ports

Icon
output of TD_SINFO

Nodes

Extensions

Links