Creating the Contains() function

To create the Contains() function:

  1. Choose Edit > Insert > Routine and type the following information in the New Routine wizard.
    Routine Property Value
    Routine Name (SQL) Contains
    Language C
    Return type Boolean
    Statement Local Variables No
    Arguments
    • Name: Circ1, Type: Circ, Default: leave blank
    • Name: Circ2, Type: Circ, Default: leave blank
    Options for how the database server calls this routine Only the Routine does not accept NULL arguments check box must be checked; clear the Routine may return inconsistent check box.
    Routine Name (C) Contains
    Shared object path Leave as default
    Behavior of Routines Well-behaved
    Special Stack Requirements None
    Cost of a Routine 0
    Related Routines None
    Object grant privileges Grant execute privileges
  2. Click Finish and then choose Project > Save to save your project.
Parent topic: Tutorial exercise 4: Creating opaque data types
Copyright© 2018 HCL Technologies Limited