TD_ColumnSummary displays the following for each specified input table column:
- Column name
- Coumn data type
- Count of these values:
- Non-NULL
- NULL
- Blank (all space characters) (NULL for numeric data type)
- Zero (NULL for nonnumeric data type)
- Positive (NULL for nonnumeric data type)
- Negative (NULL for nonnumeric data type)
- Percentage of NULL values
- Percentage of non-NULL values
- This function requires the UTF8 client character set for UNICODE data.
- This function does not support Pass Through Characters (PTCs).
For information about PTCs, see Teradata Vantage™ - Advanced SQL Engine International Character Set Support, B035-1125.
- This function does not support KanjiSJIS or Graphic data types.