After you add a DB2® SQL or IDS SPL function file to your IBM® database project, you can view the properties by using the Property Pages window. Common file-based properties are in a miscellaneous category. Display properties such as Schema Name and Function Name are in a source-based category. Most of the properties are read-only. You can configure and use specific properties during the build process.
DB2 function properties are configuration specific.
You can specify a different set of options for each solution
configuration.
To change the properties of a function:
The Properties window displays the properties of the function.
After you rebuild the function, you can run the function to verify your changes and the result set.
Developing IBM Database Functions | IBM Database Functions | Creating SQL and SPL Functions | Managing Procedures, Functions, and Objects