15.10 - FUNCTION - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1144-151K

The overloaded calling name of the function is to be renamed.

function_name
Existing overloaded calling name of the function to be changed.
You cannot rename a table operator function. For more information, see “Table Operators” in "Chapter 1 C/C++ User-Defined Functions" and "Chapter 4 Java User-Defined Functions" of SQL External Routine Programming, B035-1147.
If the UDF library for your database contains any objects with multibyte characters in their name, you cannot use a single-byte session character set to create a new UDF, UDT, method, or Java stored procedure object even if the new object name contains only single-byte characters. Otherwise, Teradata Database returns an error to the requestor. Instead, use a multibyte session character set.
If you specify function_name, then you must also specify new_function_name, not new_specific_function_name.
database_name
Containing database for function_name if something other than the current database.
user_name
Containing user for function_name if something other than the current user.
data type
Data type specifications required to uniquely identify an overloaded function to be renamed.
new_function_name
New function name for the function. For information about naming database objects, see SQL Fundamentals, B035-1141.
You cannot rename a table operator function. For more information, see “Table Operators” in "Chapter 1 C/C++ User-Defined Functions" and "Chapter 4 Java User-Defined Functions"of SQL External Routine Programming, B035-1147.

Example 2: Renaming the Overloaded Calling Name for a Function

This example renames the overloaded calling name for a function.

     RENAME FUNCTION imagine_numbers(FLOAT, FLOAT) TO imaginary;