You can use the IBM® Function Designer to change the definition of an SQL or SPL function. Alternatively, if you created an SQL or SPL function in the Visual Studio Code Editor, you can edit the source code of the SQL or SPL function.
[DB2 for z/OS® Version 10 new function mode (NFM)]
If you change the data type of a parameter from TIMESTAMP
to TIMESTAMP WITH TIMEZONE, or vice versa, the function
is not altered; it is dropped and re-created.
To change an SQL or SPL function definition:
- In the Server Explorer under your data connection, right-click the
function that you want to change, and then select Open
Definition on the shortcut menu.
The IBM Function Designer opens.
- Use the views in the designer to make the necessary changes.
For detailed information about the views and fields in the designer, see IBM Function Designer.
- From the File menu, select Save, and then close the
designer.
The SQL or SPL function under your data connection is updated with your changes.
See Also
Developing IBM Database Functions | IBM Database Functions | Changing Function Properties | Managing Procedures, Functions, and Objects
.NET Development Forum DB2 FAQs IDS FAQs
© Copyright IBM Corporation 2002, 2019. All Rights Reserved.