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

Teradata® Fabric - Installation and User Guide - 3.11

Product
Teradata Fabric
Release Number
3.11
Published
August 2026
ft:locale
en-US
ft:lastEdition
2026-08-15
dita:mapPath
svw1780362788070.ditamap
dita:ditavalPath
ezw1784752870623.ditaval
dita:id
lxg1591800469257

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