Copy Function Alias Objects | Teradata Data Mover - 17.11 - About Copying Function Alias Objects - Teradata Data Mover

Teradata® Data Mover User Guide

Product
Teradata Data Mover
Release Number
17.11
Release Date
October 2021
Content Type
User Guide
Publication ID
B035-4101-091K
Language
English (United States)

Function alias, also referred to as function mapping, allows you to create simple, alternate names to foreign function objects or foreign servers. A function alias is different from an SQL statement alias, where an alias in a SQL statement is a temporary name, the function alias is a new permanent object in the database. A function alias hides details such as name and location for the foreign function being run.

Data Mover supports copying function alias objects from one Teradata system to another Teradata system that supports the function alias feature. Make sure all dependent objects in the function alias object definition exists in the target system before copying, Data Mover does not validate that all dependent objects in the function alias object exists in the target system.

The following parameters are used to copy a function alias object:
Parameter Description
name Function alias object name.
database Owner or database name where the function alias object exists.

Requirements and Restrictions

  • The Data Mover job user must be granted ACCESS permissions to function alias objects in the source system to run the SHOW FUNCTION MAPPING for DDL and DROP and CREATE function alias objects in the target system, otherwise the job fails at run time.
  • All dependent objects in the function alias object must exist in the target system, otherwise the job fails at run time. Data Mover does not validate the existence of dependent objects.
  • Both the source and target Teradata Database systems must be version 16.20 Feature Update 1 or later.
  • Data Mover only supports copying function alias objects; renaming or relocating of objects to a different target database is not supported.
  • Function alias objects can be copied using DSA, TPT, or JDBC.
  • When copying an entire database using DSA, the function alias objects in the database are also copied.
  • Data Mover does not parse the function alias object DDL, the same source DDL is run on the target system.

Example

The following example shows the function alias object DDL for a foreign server in the database TD_SERVER_DB. For more information about the function alias object feature, refer to the Teradata Database documentation.

CREATE FUNCTION MAPPING myDB.FAObjForForeignSer FOR TD_SERVER_DB.td_conn_get_supp_version SERVER TD_SERVER_DB.MyForeignServerObject;