CREATE FUNCTION MAPPING and REPLACE FUNCTION MAPPING Syntax Elements - Advanced SQL Engine - Teradata Database

SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Published
January 2021
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
ncd1596241368722.ditamap
dita:ditavalPath
hoy1596145193032.ditaval
dita:id
B035-1144
lifecycle
previous
Product Category
Teradata Vantage™
database_name_1
Name of database to contain the function mapping, if other than the current database.
user_name_1
Name of user to contain the function mapping, if other than the current user.
function_mapping_name
Name of function mapping. For information on naming objects, see Teradata Vantage™ - SQL Fundamentals.
database_name_2
Name of the database containing the function, if other than the current database for the session.
user_name_2
Name of the user containing the function, if other than the current user for the session.
schema_name
Name of schema associated with function.
function_name
Name of function or table operator to map.
You must make sure that the function is present in the location you specify.
For functions or table operators stored within the database, if you do not specify a database or user, the location defaults to the following, in order of precedence:
  • Current default database or user for the session
  • SYSLIB
  • TD_SYSFNLIB
See Example: Function Mapping Definition for a Function Within the Database.
SERVER
Name of external server where the function or table operator is located.
For a function or table operator within the database, you do not specify the SERVER clause.
database_name_3
Name of database to contain the function, if other than the current database.
user_name_3
Name of user to contain the function, if other than the current user.
server_name
Name of server containing the function.
EXTERNAL SECURITY
Specifies an authorization for accessing remote storage. See CREATE AUTHORIZATION and REPLACE AUTHORIZATION. You can specify the DEFINER option to share an authorization object with multiple users. You specify the INVOKER option to allow exclusive access by a user.
DEFINER TRUSTED
This authorization can be created in any database. The authorization must be created as DEFINER TRUSTED.
TRUSTED
INVOKER TRUSTED
This authorization is created in the current user's database.
authorization_name
Name of authorization.
json_document
JSON format document containing input to function in the form of parameters and values.