About Copying Functions | Teradata Data Mover - About Copying Functions - Teradata Data Mover

Teradata® Data Mover User Guide

Product
Teradata Data Mover
Release Number
17.12
Published
January 2022
Language
English (United States)
Last Update
2022-01-18
dita:mapPath
ptl1635805434108.ditamap
dita:ditavalPath
mpm1591127278842.ditaval
dita:id
B035-4101
lifecycle
previous
Product Category
Analytical Ecosystem
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>