Options for routines

If you choose to program your user-defined routines in C, you can choose any of the routine options available in BladeSmith.

When you implement a routine in Java™, you cannot specify the following options:
  • That it has a selectivity function or is a selectivity function.
  • That it takes row data types or collection data types as arguments.
  • That it is internal.
  • Its stack size
  • Its cost.
  • That it has a commutator function or is a commutator function.
Tip: You can also choose to implement routines in HCL OneDB™ Stored Procedure Language (SPL).