TD_MATRIXMULTIPLY Syntax Elements - Teradata Vantage

Database Unbounded Array Framework Time Series Functions

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2024-10-04
dita:mapPath
ncd1634149624743.ditamap
dita:ditavalPath
ruu1634160136230.ditaval
dita:id
ncd1634149624743
MATRIX_SPEC
The specifications for the primary and secondary matrixes. The first matrix referenced in the function is the primary matrix. The second matrix is the secondary matrix. The column count of the primary matrix must be equal to the row count of the secondary matrix. The result matrix always inherits the identifiers, MATRIX_ID() from the primary matrix.

See Matrix Specifications.

INPUT_FMT
Mandatory specification. The INPUT_MODE parameter has the following options:
  • ONE2ONE: Both the primary and secondary matrixes specifications include a WHERE filter clause identifying one matrix instance to serve as the input series for the mathematical operation.
  • MANY2ONE: The primary input MATRIX_SPEC references MANY series instances. The secondary input MATRIX_SPEC includes a WHERE filter clause identifying a single matrix instance. When applying the mathematical operation, the secondary input single matrix is reused as many times as necessary to match the number of matrix instances found in the primary input.
  • MATCH: A matrix instance residing in the primary input whose MATRIX_ID matches the MATRIX_ID of a matrix instance in the secondary input, has the mathematical operation applied to produce a result matrix. For those instances in one input who have no corresponding MATRIX_ID partner in the other input, the matrix is skipped over.
OUTPUT_FMT
No OUTPUT_FMT options are available for this function.