User-defined routine execution

The DataBlade® API provides routines for executing user-defined routines (UDRs).

Table 1. DataBlade API functions for executing UDRs

Function category DataBlade API function DataBlade API function
Accessing the MI_FPARAM structure

mi_fp_argisnull()
mi_fp_arglen()
mi_fp_argprec()
mi_fp_argscale()
mi_fp_argtype()
mi_fp_funcname()
mi_fp_funcstate()
mi_fp_getcolid()
mi_fp_getfuncid()
mi_fp_getrow()
mi_fp_nargs()
mi_fp_nrets()
mi_fp_request()
mi_fp_retlen()
mi_fp_retprec()
mi_fp_retscale()
mi_fp_rettype()

Advanced functions:

mi_fp_setcolid()
mi_fp_setrow()
mi_fparam_get_current()

mi_fp_returnisnull()
mi_fp_setargisnull()
mi_fp_setarglen()
mi_fp_setargprec()
mi_fp_setargscale()
mi_fp_setargtype()
mi_fp_setfuncid()
mi_fp_setfuncstate()
mi_fp_setisdone()
mi_fp_setnargs()
mi_fp_setnrets()
mi_fp_setretlen()
mi_fp_setretprec()
mi_fp_setretscale()
mi_fp_setrettype()
mi_fp_setreturnisnull()

Allocating an MI_FPARAM structure

mi_fp_usr_fparam()
mi_fparam_allocate()

mi_fparam_copy()
mi_fparam_free()

Using the Fastpath interface

mi_cast_get()
mi_func_desc_by_typeid()
mi_routine_end()
mi_routine_exec()

mi_routine_get()
mi_routine_get_by_typeid()
mi_td_cast_get()

Accessing a function descriptor

mi_fparam_get()
mi_func_commutator()
mi_func_handlesnulls()

mi_func_isvariant()
mi_func_negator()
mi_routine_id_get()

Execute an operating system command mi_system()