This Teradata QueryGrid connector Data Dictionary view provides details about the name value pairs used by foreign servers defined in the Vantage 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. |