Unless otherwise noted, every syntax element that is a name must follow the rules for naming database objects. See Object Names.
- 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.
- EXECUTE PROTECTED
- Change the run mode for the specified function from unprotected mode to protected mode. For details, see When to Specify Unprotected Mode (ALTER FUNCTION External Form).
- EXECUTE NOT PROTECTED
- Change the run 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.