Creating the rciDistance() function

To create the rciDistance() function:

  1. Choose Edit > Insert > Routine and type the following information in the New Routine wizard.
    Routine Property Value
    Routine Name (SQL) rciDistance
    Language C
    Return type double precision
    Statement Local Variables No
    Arguments
    • Name: point1, Type: rciPoint, Default: none
    • Name: point2, Type: rciPoint, Default: none
    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) rciDistance
    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 3: Creating row data types
Copyright© 2019 HCL Technologies Limited