Home
Extending HCL OneDB™Beyond standard relational database objects, HCL OneDB™ can be extended to handle specialized data types, access methods, routines, and other objects. HCL OneDB™ includes many built-in extensions that are fully integrated in the database server. HCL OneDB™ also provides DataBlade® modules, which are packages of extended database objects for a particular purpose and that are installed separately from the database server. Alternatively, you can create your own user-defined objects for HCL OneDB™.
Creating extensionsYou can create user-defined data types, routines, access methods, and other database objects to suit your needs. You can use application programming interfaces to write user-defined routines and applications that access data in HCL OneDB™ databases.
DataBlade® API Function ReferenceThe HCL OneDB™ DataBlade® API Function Reference describes the DataBlade® API functions and the subset of functions that the DataBlade® API supports.
Categories of DataBlade® API functionsThis section summarizes by categories the functions that the DataBlade® API provides. It divides functions that are valid within DataBlade® API modules into several functional categories and lists the functions within each category.
The DataBlade® API function libraryThis section lists the functions in the DataBlade® API function library by categories.
Selectivity and cost functionsThe DataBlade® API provides routines for accessing the MI_FUNCARG data type, which is the data type of all parameters of selectivity and cost functions.

Selectivity and cost functions

The DataBlade® API provides routines for accessing the MI_FUNCARG data type, which is the data type of all parameters of selectivity and cost functions.

Table 1. DataBlade API functions for accessing the **MI_FUNCARG** data type
Function category	DataBlade API function
Accessing the MI_FUNCARG data type	mi_funcarg_get_argtype() mi_funcarg_get_colno() mi_funcarg_get_constant() mi_funcarg_get_datalen() mi_funcarg_get_datatype()	mi_funcarg_get_distrib() mi_funcarg_get_routine_id() mi_funcarg_get_routine_name() mi_funcarg_get_tabid() mi_funcarg_isnull()