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. |