Search code examples
sqlinformix

Alter Function - Informix DB

I'm a newbie to Informix world. How to modify or update a user-defined function in Informix database? Tried below query:

ALTER FUNCTION function_name().....

It didn't work. I'm getting syntax error.

Solution

  • Unfortunately doesn't exists alter function to change the body for Informix database. You need to drop and create it again.

    Be careful, save the grants before to replicate them after recreate the function and make sure not have set the pdqpriority at the session where you will create it.