Data handling

The DataBlade API provides categories of functions for handling data.

Table 1. DataBlade API functions for handling data
Function category DataBlade API function DataBlade API function
Obtaining type information from type-descriptor accessor functions

mi_type_align()
mi_type_byvalue()
mi_type_constructor_typedesc()
mi_type_element_typedesc()
mi_type_full_name()
mi_type_length()
mi_type_maxlength()

mi_type_owner()
mi_type_precision()
mi_type_qualifier()
mi_type_scale()
mi_type_typename()
mi_typedesc_typeid()

Obtaining type information from type-identifier accessor functions

mi_typeid_equals()
mi_typeid_is_builtin()
mi_typeid_is_collection()
mi_typeid_is_complex()
mi_typeid_is_distinct()

mi_typeid_is_list()
mi_typeid_is_multiset()
mi_typeid_is_row()
mi_typeid_is_set()

Obtaining type information from other functions

mi_get_transaction_id()
mi_type_typedesc()
mi_typename_to_id()

mi_typename_to_typedesc()
mi_typestring_to_id()
mi_typestring_to_typedesc()

Transferring data types between computers (server side only)

mi_fix_integer()
mi_fix_smallint()
mi_get_bigint()
mi_get_bytes()
mi_get_date()
mi_get_datetime()
mi_get_decimal()
mi_get_double_precision()
mi_get_int8()
mi_get_integer()
mi_get_interval()
mi_get_lo_handle()
mi_get_money()
mi_get_real()
mi_get_smallint()

mi_get_string()
mi_put_bigint()
mi_put_bytes()
mi_put_date()
mi_put_datetime()
mi_put_decimal()
mi_put_double_precision()
mi_put_int8()
mi_put_integer()
mi_put_interval()
mi_put_lo_handle()
mi_put_money()
mi_put_real()
mi_put_smallint()
mi_put_string()

Converting data types

mi_date_to_string()
mi_datetime_to_string()
mi_decimal_to_string()
mi_interval_to_string()
mi_lvarchar_to_string()
mi_money_to_string()

Deprecated functions:

mi_binary_to_date()
mi_binary_to_datetime()
mi_binary_to_decimal()
mi_binary_to_money()

mi_string_to_date()
mi_string_to_datetime()
mi_string_to_decimal()
mi_string_to_interval()
mi_string_to_lvarchar()
mi_string_to_money()

Deprecated functions:

mi_date_to_binary()
mi_datetime_to_binary()
mi_decimal_to_binary()
mi_money_to_binary()

Comparing data types mi_datetime_compare() mi_interval_compare()
Converting data between code sets on the server side mi_get_string() mi_put_string()
Handling collections

mi_collection_card()
mi_collection_close()
mi_collection_copy()
mi_collection_create()
mi_collection_delete()
mi_collection_fetch()

mi_collection_free()
mi_collection_insert()
mi_collection_open()
mi_collection_open_
with_options()

mi_collection_update()

Managing varying-length structures

mi_get_vardata()
mi_get_vardata_align()
mi_get_varlen()
mi_lvarchar_to_string()
mi_new_var()
mi_set_vardata()
mi_set_vardata_align()

mi_set_varlen()
mi_set_varptr()
mi_string_to_lvarchar()
mi_var_copy()
mi_var_free()
mi_var_to_buffer()

Obtaining SERIAL values mi_last_serial() mi_last_serial8()
Accessing multirepresentational data types mi_lo_expand()

Macros:

mi_issmall_data()

mi_set_large()

Handling NULL values

mi_column_nullable()
mi_fp_argisnull()
mi_fp_returnisnull()
mi_fp_setargisnull()

mi_fp_setreturnisnull()
mi_func_handlesnulls()
mi_funcarg_isnull()
mi_parameter_nullable()

Obtaining trigger information

mi_trigger_event()
mi_trigger_get_new_row()
mi_trigger_get_old_row()

mi_trigger_level()
mi_trigger_name()
mi_trigger_tabname()

Obtaining High-Availability Data Replication information mi_hdr_status()  

Copyright© 2019 HCL Technologies Limited