Copy Function Alias Object Definition | Teradata Data Mover - 17.11 - Copying Function Alias Object Definition - 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)
You can copy function alias objects from a source Teradata system to a target Teradata system.
  1. Copy the full database using a utility such as DSA and specifying the selection="included" database attribute.
    <dmCreate>
    ...
    	<database selection="included">
    		<name>MyDB</name>
    	</database>
    ...
    </dmCreate>
    
  2. In the job definition, set the selection="include" attribute for each of the function_alias parameters.
    <function_aliases>
        <function_alias selection="included" >
            <name>dmguest</name>
            <database>faObj</database>
        </function_alias>
        <function_alias selection="included" >
            <name>FAObjForForeignSer</name>
            <database>myDB</database>
        </function_alias>
    </function_aliases>