Creating SQL and SPL Functions from Existing Functions

If you want to create an SQL or SPL function that is similar to an SQL function in your IBM^® database, you can base the new function on the existing function definition.

To create an SQL or SPL function from an existing function:

In the Server Explorer under your IBM data connection, expand the Functions folder.
Right-click the function that you want to use as the basis for the new function, and then select Clone Definition on the shortcut menu.
The IBM Function Designer opens, with the information for the selected function displayed in the fields of the designer. The values in the Function name and Specific name fields contain an incremental numeric suffix.
Change, add, or delete the information in the views of the designer to define the new function.
For detailed information about the fields in the designer views, see IBM Function Designer.
Save the function definition.
The SQL or SPL function is created and added to your database.
Close the designer.

See Also