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

Input ports

1. Type: DB Session
   Teradata Connection
   Connection to a Teradata Database Instance
2. Type: Table
   Input
   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

1. Type: Table
   output of TD_SINFO
   output of TD_SINFO