Using BladeSmith to create the AddIntegers() function

To create the AddIntegers() function:

  1. Choose Edit > Insert > Routine and type the following information in the New Routine wizard.
    Routine property AddIntegers value
    Routine Name (SQL) AddIntegers
    Language C
    Return type integer
    Statement Local Variables No
    Arguments
    • Name: Int1 Type: integer Default: leave blank
    • Name: Int2 Type: integer Default: leave blank
    Routine Calling Options Only the Routine does not accept NULL arguments check box must be checked; clear the Routine may return inconsistent check box.
    Routine Name (C) AddInts
    Shared object path Leave as default
    Behavior of Routines Routine is well-behaved
    Special Stack Requirements Leave blank
    Cost of a Routine 0
    Related Routines None
    Object grant privileges Grant execute privileges
  2. Click Finish. The AddIntegers() function appears in the User Defined Objects folder.
  3. Choose Project > Save to save the changes to your DataBlade module.
Parent topic: Tutorial exercise 1: Creating a simple user-defined routine
Copyright© 2019 HCL Technologies Limited