- database_name_1
- The containing database for specific_function_name, if something other than the current database.
- user_name_1
- The containing user for specific_function_name, if something other than the current user.
- specific_function_name
- The specific function name for the function to be altered.
- database_name_2
- The containing database for function_name, if other than the current database.
- user_name_2
- The containing user for function_name, if other than the current user.
- function_name
- Name of the function to alter.
- data_type
- An optional data type specification for the parameters passed to function_name.
- UDT_name
- The name of any UDT included in the list of data types for function_name.
- EXECUTE PROTECTED
- Change the execution mode for the specified function from unprotected mode to protected mode. For details, see the ALTER FUNCTION topic "When to Specify Unprotected Mode" in Teradata Vantage™ - SQL Data Definition Language Detailed Topics , B035-1184 .
- EXECUTE NOT PROTECTED
- Change the execution mode for the specified function from protected mode to unprotected mode.
- COMPILE
- This option performs the following actions:
C or C++ function Java function Recompiles the code source for the specified function. Recompiles the code source for the specified function. Generates the object code. Generates the object code. Recreates the .so file. Distributes the related JAR files for the function. Distributes the .so file to all nodes of the system. - ONLY
- Recompile the UDF only. When you specify this option, Vantage does not distribute a new dynamic linked library to database nodes.