-20073 THE FUNCTION `function-name` CANNOT BE ALTERED BECAUSE IT IS REFERENCED IN EXISTING VIEW OR MATERIALIZED QUERY TABLE DEFINITIONS

function-name

Explanation
 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 processed.

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. 

SQLSTATE
 42927

-20073 THE FUNCTION function-name CANNOT BE ALTERED BECAUSE IT IS REFERENCED IN EXISTING VIEW OR MATERIALIZED QUERY TABLE DEFINITIONS

Explanation

System action

Programmer response

SQLSTATE

-20073 THE FUNCTION `function-name` CANNOT BE ALTERED BECAUSE IT IS REFERENCED IN EXISTING VIEW OR MATERIALIZED QUERY TABLE DEFINITIONS