ALTER FOREIGN SERVER | Modify Options | Teradata Connector | QueryGrid - Modify Options - Teradata QueryGrid

QueryGridâ„¢ Installation and User Guide - 3.06

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata QueryGrid
Release Number
3.06
Published
December 2024
ft:locale
en-US
ft:lastEdition
2024-12-07
dita:mapPath
ndp1726122159943.ditamap
dita:ditavalPath
ft:empty
dita:id
lxg1591800469257
lifecycle
latest
Product Category
Analytical Ecosystem

ADD

Use to:
  • Add or replace a global name value pair that is used to define the server object
  • Add an IMPORT or EXPORT table operator. To replace a table operator already associated with the foreign server, you must first drop the table operator before adding the new one.
name('value')
The External Name Value pair or pairs (LINK and VERSION) to add or modify.

The name value pair or pairs define the properties of the foreign server. The name value pairs are defined in the QueryGrid portlet. You can create separate named link configurations for unique sets of properties and you can create different versions (active, pending, previous) of the links. For more information, see Teradata Connector and Link Properties.

You can change the External Name Value pairs in ALTER FOREIGN SERVER. To modify the properties of the named link, use the QueryGrid portlet.

In the description of the name value pairs:
  • The label "Server only" indicates that the name value pair must follow the syntax ADD name('value').
  • The label "Import only" indicates that the name value pair must be specified after the IMPORT keyword.
  • The label "Export only" indicates that the name value pair must be specified after the EXPORT keyword.
  • You can specify unlabeled name value pairs in any part of the ADD syntax. If specified as ADD name('value'), the name value pair is applied to the server as a whole.
IMPORT
Indicates that you are going to act on the operator that is used to import data into the Teradata system.
EXPORT
Indicates that you are going to act on the operator that is used to export data out of the Teradata system.
operator_name
The name of the table operator to use.
For more information about the table operators used with the server object, see CREATE FOREIGN SERVER.