DB2 SQL-Error: -20073
SQLState: 42927
Short Description: THE FUNCTION CANNOT BE ALTERED BECAUSE IT IS REFERENCED IN EXISTING VIEW OR MATERIALIZED QUERY TABLE DEFINITIONS
The function-name in an ALTER FUNCTION statement cannot be altered to NOT DETERMINISTIC or EXTERNAL ACTION. It is referenced in one or more existing view definitions or materialized query table definitions. System action: The statement cannot be executed. Programmer response: Drop the views that reference the function before issuing the ALTER FUNCTION statement. Drop the materialized query tables that reference the functions or alter the materialized query tables that reference the functions into base tables before issuing the ALTER FUNCTION statement.