Can a User Defined Function such as a scalar UDF to return only clean characters?
For example, select nm_frst, NM_LST, DB2ADMIN.UDF_CleanChar('a@b#c$d%e%f^g') should return only "abcdefg".
I want to try to automatically trigger a background call to this UDF_Clean_Char whenever a user enters data in selected application fields. The key to this question and points:
Is that possible? How can it be done?