17.10 - Usage Notes - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Data Dictionary

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Administration
Programming Reference
Publication ID
B035-1092-171K
Language
English (United States)

This Teradata QueryGrid connector view returns the name value pairs defined for a foreign server for the associated table operator, such as IMPORT or EXPORT table operators.

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 TableOperatorType

  • IMPORT
  • EXPORT
  • UNKNOWN

Possible Values for ValueType

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

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