You can copy function alias objects from a source Teradata system to a target Teradata system.
- Copy the full database using a utility such as ARC or DSA and specifying the selection="included" database attribute.
<dmCreate> ... <database selection="included"> <name>MyDB</name> </database> ... </dmCreate>
- 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>