The IBM® Database Add-Ins for Visual Studio simplify the process of creating and modifying IBM database functions.
In DB2®, a function is an extension or addition to existing built-in SQL functions. In IBM Informix Dynamic Server (IDS), user-defined functions are routines that are written in SQL and Informix Stored Procedure Language (SPL), which is an extension to SQL.
Functions can return a single value, a value with a complex data type, or multiple values.
To open the IBM Function Designer:
- If you want to create a function, in the Server Explorer under your data connection, right-click Functions, and then select Add New Function with Designer on the shortcut menu.
- If you want to create a function that is based on an existing function, in the Server Explorer under your data connection, right-click the function that you want to use, and then select Clone Definition on the shortcut menu.
- If you want to modify a function, 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.
IBM Function Designer toolbar
Use the buttons on the IBM Function Designer toolbar to move from view to view in the designer and to perform actions on the SQL or SPL function.
- Moves to the
Function view
- Moves to the
Privileges view
- Runs the function so that you can test it
- Moves to the
Show Script view
See Also
Developing IBM Database Functions | IBM Database Functions | Creating SQL and SPL Functions | Changing SQL and SPL Function Definitions | Managing Procedures, Functions, and Objects
.NET Development Forum DB2 FAQs IDS FAQs
© Copyright IBM Corporation 2002, 2019. All Rights Reserved.