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