Creating a Function

Procedure

  1. On the top menu bar, choose Database Management. On the displayed Objects page, select Functions, and click Create Function.

    Figure 1 Creating a function

  2. In the displayed dialog box, specify the function name, returned value, and description, and click OK.

    Figure 2 Editing a function

  3. On the displayed page, edit the function body.

    Figure 3 Editing a function body

  4. In the upper left corner, click Option. In the displayed dialog box, set required parameters and click OK.

    Figure 4 Setting required parameters

  5. Click Save, or click Execute and view the status in the Message area.

    Figure 5 Executing a function