Creating the user-defined routines

About this task

The Mercury DataBlade® module uses two user-defined routines to prevent users from entering values below absolute zero in the data types CTemp and FTemp. In this DataBlade® module, you implement Assign() functions for the FTemp and CTemp data types. The C functions that implement the Assign() functions are named FTempAssign() and CTempAssign(). The server calls the appropriate routine before it stores a value for either of the two temperature types.

To create the Assign() functions:

Procedure

  1. Choose Edit > Insert > Routine and type the following information, once for each routine, in the New Routine wizard.
    Routine property FTempAssign value CTempAssign value
    Routine Name (SQL) assign assign
    Language C C
    Return type FTemp CTemp
    Statement Local Variables No No
    Arguments Name: temperature, Type: FTemp Default: leave blank Name: temperature, Type: CTemp, 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. Only the Routine does not accept NULL arguments check box must be checked; clear the Routine may return inconsistent check box.
    Routine Name (C) FTempAssign CTempAssign
    Shared object path Default Default
    Behavior of Routines Routine is well-behaved Routine is well-behaved
    Special Stack Requirements None None
    Cost of a Routine 0 0
    Related Routines None None
    Object grant privileges Grant execute privileges Grant execute privileges
  2. Click Finish and then choose Project > Save to save your project.