16.20 - Usage Notes - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ Data Dictionary

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-03
dita:mapPath
zzu1512081120577.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval

This Teradata QueryGrid connector Data Dictionary view provides details about the name value pairs used by foreign servers defined in the Teradata Database system.

NameInfo and ValueInfo

NameInfo returns the name portion specified in the USING custom clause. ValueInfo returns the value portion specified in the USING custom clause.

Possible Values for NVPType

NVPType returns the name value pair type or UNKNOWN:
  • IMPORT
  • EXPORT
  • GLOBAL
  • UNKNOWN

Possible Values for ValueType

ValueType identifies what type of value is specified in the USING custom clause.

Value Description
NULL ValueInfo column contains data value.
F Indicates a foreign table.
R ValueInfo column contains a resolved query text mentioned in NVP.
S ValueInfo column contains query text mentioned in NVP query.
V ValueInfo column contains a system variable.