TD_MINFO

The TD_MINFO, 'Matrix Information', function is an AF Utility function used to return metadata describing the logical matrix identified by the MATRIX_SPEC specification passed into the function. For each matrix this function returns:. Matrix Row/Column Index Data type - TIMESTAMP, TIMESTAMP WITH TIME ZONE, DATE, INTEGER, or FLOAT. Starting Row/Column Index value associated with the matrix . Ending Row/Column Index value associated with the matrix . Count of total number of entries for Row/Column Index. Flag indicating whether the matrix is regular or irregular along Row/Column Index. Row/Column Index Sample interval - row/column index sample interval associated with a discrete row/column index; or, alternatively, average of all row/column index sample intervals encountered, if it has an irregular row/column index.. 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” entry: Minimum sample magnitude encountered in matrix; Maximum sample magnitude encountered in matrix; Average of all magnitudes encountered in matrix. Count of total number of null value in all the result payload fields.. Flag indicating whether the matrix is malformed or well input matrix.

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 matrices described by a matrix specification, MATRIX_SPEC. These logical matrices 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_MINFO
   output of TD_MINFO