DB2 syscat.functions table

[infoforlife]

Hi,

I was looking at a list of user generated functions from the syscat.functions table, and I noticed that some of the deleted functions (by using DataStudio), still appear in that table. This is problematic to me, because I want to use that table to get all the function signatures and generate tables from them, avoiding the deleted functions, obviously.

Is there a flag somewhere which will tell me firmly which function is inactive/deleted?

If not, is it safe for me to delete those functions directly from the syscat.functions table, and what are the cascading dependencies (in deletion) that I have to follow.

Thanks for your help.