In Data Mover, use DSA to copy functions. Following restrictions apply:
- Grant the create function and alter function privileges to the source and target users.
- Copy only the following functions using DSA:
- A - AGGREGATE_FUNCTION
- F - STANDARD_FUNCTION
- R - TABLE_FUNCTION
- L - TABLE_OPERATOR
- C - CONTRACT_FUNCTION
- Mention the specific name of the function as the function name. The specific name is always unique, but is not the function name.The specific name of a function is defined in the SPECIFIC clause when created. If the SPECIFIC clause is not used, then database generates specific name for a function. You may find that value in the tableName field in dbc.tablesV. Refer to the Teradata Vantage™ - SQL External Routine Programming, B035-1147 to define a function.
- Use only DSA to copy functions. If you use other utilities, validation errors may occur.
The DLLs of the copied functions may not be in a usable state at the target database.
Example of the copying function:
<database selection="included">
<name>DBName</name>
</database>
<functions>
<function selection="included">
<name>MY_Function</name>
<database>MyDB</database>
</function>
</functions>