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()