I am trying to change the parameter name of an SQL function using an SQL command. ALTER FUNCTION seems possible but I’m unsure of the syntax. Here is the signature:
CREATE OR REPLACE FUNCTION ADVISORS_DEV.EXTERNAL_DATA_UPLOADS.ADDONE("ARG1" FLOAT)
And I’m trying to change ARG1
.
https://www.ibm.com/docs/en/db2-for-zos/12?topic=statements-alter-function-compiled-sql-scalar says “The function options, parameter names, and routine body can be changed…” with ALTER FUNCTION.
Thanks
New contributor
David George is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.