Informix DataBlade API Programmer's Manual DataBlade API Function Descriptions

In This Chapter

Categories of DataBlade API Functions

The DataBlade API Function Library

Data Handling

Session, Thread, and Transaction Management

Processing SQL Statements

Executing a User-Defined Routine

Executing a Selectivity or Cost Function

Managing Memory

Handling Exceptions

Using the Smart-Large-Object Interface

Using the Operating-System File Interface

Tracing

Managing Databases

Miscellaneous

The ESQL/C Function Library

Function Descriptions

bycmpr()

bycopy()

byfill()

byleng()

decadd()

deccmp()

deccopy()

deccvasc()

deccvdbl()

deccvint()

deccvlong()

decdiv()

dececvt() and decfcvt()

decmul()

decround()

decsub()

dectoasc()

dectodbl()

dectoint()

dectolong()

dectrunc()

dtaddinv()

dtcurrent()

dtcvasc()

dtcvfmtasc()

dtextend()

dtsub()

dtsubinv()

dttoasc()

dttofmtasc()

ifx_int8add()

ifx_int8cmp()

ifx_int8copy()

ifx_int8cvasc()

ifx_int8cvdbl()

ifx_int8cvdec()

ifx_int8cvflt()

ifx_int8cvint()

ifx_int8cvlong()

ifx_int8div()

ifx_int8mul()

ifx_int8sub()

ifx_int8toasc()

ifx_int8todbl()

ifx_int8todec()

ifx_int8toflt()

ifx_int8toint()

ifx_int8tolong()

incvasc()

incvfmtasc()

intoasc()

intofmtasc()

invdivdbl()

invdivinv()

invextend()

invmuldbl()

ldchar()

mi_alloc()

mi_binary_to_date()

mi_binary_to_datetime()

mi_binary_to_decimal()

mi_binary_to_money()

mi_binary_query()

mi_call()

mi_cast_get()

mi_client()

mi_client_locale()

mi_close()

mi_close_statement()

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

mi_column_count()

mi_column_id()

mi_column_name()

mi_column_nullable()

mi_column_precision()

mi_column_scale()

mi_column_type_id()

mi_column_typedesc()

mi_command_is_finished()

mi_current_command_name()

mi_dalloc()

mi_date_to_binary()

mi_datetime_to_binary()

mi_date_to_string()

mi_datetime_to_string()

mi_db_error_raise()

mi_dbcreate()

mi_dbdrop()

mi_decimal_to_binary()

mi_decimal_to_string()

mi_default_callback()

mi_disable_callback()

mi_drop_prepared_statement()

mi_enable_callback()

mi_errmsg()

mi_error_desc_copy()

mi_error_desc_destroy()

mi_error_desc_finish()

mi_error_desc_is_copy()

mi_error_desc_next()

mi_error_level()

mi_error_sqlcode()

mi_error_sql_state()

mi_exec()

mi_exec_prepared_statement()

mi_fetch_statement()

mi_file_allocate()

mi_file_close()

mi_file_errno()

mi_file_open()

mi_file_read()

mi_file_seek()

mi_file_sync()

mi_file_tell()

mi_file_to_file()

mi_file_to_large_object()

mi_file_unlink()

mi_file_write()

mi_fix_integer()

mi_fix_smallint()

mi_fp_argisnull()

mi_fp_arglen()

mi_fp_argprec()

mi_fp_argscale()

mi_fp_argtype()

mi_fp_funcstate()

mi_fp_getcolid()

mi_fp_getrow()

mi_fp_nargs()

mi_fp_nrets()

mi_fp_request()

mi_fp_retlen()

mi_fp_retprec()

mi_fp_retscale()

mi_fp_rettype()

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

mi_fp_usr_fparam()

mi_fparam_allocate()

mi_fparam_copy()

mi_fparam_free()

mi_fparam_get()

mi_free()

mi_func_desc_by_typeid()

mi_func_handlesnulls()

mi_func_isvariant()

mi_func_negator()

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

mi_get_bytes()

mi_get_connection_info()

mi_get_connection_option()

mi_get_connection_user_data()

mi_get_database_info()

mi_get_date()

mi_get_datetime()

mi_get_dbnames()

mi_get_decimal()

mi_get_default_connection_info()

mi_get_default_database_info()

mi_get_double_precision()

mi_get_id()

mi_get_int8()

mi_get_integer()

mi_get_interval()

mi_get_lo_handle()

mi_get_money()

mi_get_next_sysname()

mi_get_parameter_info()

mi_get_real()

mi_get_result()

mi_get_row_desc()

mi_get_row_desc_from_type_desc()

mi_get_row_desc_without_row()

mi_get_serverenv()

mi_get_smallint()

mi_get_statement_row_desc()

mi_get_string()

mi_get_type_source_type()

mi_get_vardata()

mi_get_vardata_align()

mi_get_varlen()

mi_init_library()

mi_interrupt_check()

mi_interval_to_string()

mi_library_version()

mi_issmall_data()

mi_large_object_close()

mi_large_object_copy()

mi_large_object_copy_opts()

mi_large_object_create()

mi_large_object_create_opts()

mi_large_object_decrefcount()

mi_large_object_expand()

mi_large_object_filename()

mi_large_object_increfcount()

mi_large_object_info()

mi_large_object_map()

mi_large_object_open()

mi_large_object_pin()

mi_large_object_read()

mi_large_object_readwithseek()

mi_large_object_seek()

mi_large_object_stat()

mi_large_object_tell()

mi_large_object_to_file()

mi_large_object_unmap()

mi_large_object_unpin()

mi_large_object_write()

mi_last_serial()

mi_last_serial8()

mi_lo_alter()

mi_lo_close()

mi_lo_colinfo_by_ids()

mi_lo_colinfo_by_name()

mi_lo_copy()

mi_lo_create()

mi_lo_decrefcount()

mi_lo_delete_immediate()

mi_lo_expand()

mi_lo_filename()

mi_lo_from_buffer()

mi_lo_from_file()

mi_lo_from_file_by_lofd()

mi_lo_from_string()

mi_lo_increfcount()

mi_lo_invalidate()

mi_lo_lock()

mi_lo_lolist_create()

mi_lo_open()

mi_lo_ptr_cmp()

mi_lo_read()

mi_lo_readwithseek()

mi_lo_release()

mi_lo_seek()

mi_lo_spec_free()

mi_lo_spec_init()

mi_lo_specget_def_open()

mi_lo_specget_estbytes()

mi_lo_specget_extsz()

mi_lo_specget_flags()

mi_lo_specget_maxbytes()

mi_lo_specget_sbspace()

mi_lo_specset_def_open()

mi_lo_specset_estbytes()

mi_lo_specset_extsz()

mi_lo_specset_flags()

mi_lo_specset_maxbytes()

mi_lo_specset_sbspace()

mi_lo_stat()

mi_lo_stat_atime()

mi_lo_stat_cspec()

mi_lo_stat_ctime()

mi_lo_stat_free()

mi_lo_stat_mtime_sec()

mi_lo_stat_refcnt()

mi_lo_stat_size()

mi_lo_tell()

mi_lo_to_buffer()

mi_lo_to_file()

mi_lo_to_string()

mi_lo_truncate()

mi_lo_unlock()

mi_lo_validate()

mi_lo_write()

mi_lo_writewithseek()

mi_login()

mi_lvarchar_to_string()

mi_money_to_binary()

mi_money_to_string()

Return Values

mi_new_var()

mi_next_row()

mi_open()

mi_open_prepared_statement()

mi_parameter_count()

mi_parameter_nullable()

mi_parameter_precision()

mi_parameter_scale()

mi_parameter_type_id()

mi_parameter_type_name()

mi_prepare()

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

mi_query_finish()

mi_query_interrupt()

mi_register_callback()

mi_result_command_name()

mi_result_row_count()

mi_retrieve_callback()

mi_routine_end()

mi_routine_exec()

mi_routine_get()

mi_routine_get_by_typeid()

mi_routine_id_get()

mi_row_create()

mi_row_desc_create()

mi_row_desc_free()

mi_row_free()

mi_save_set_count()

mi_save_set_create()

mi_save_set_delete()

mi_save_set_destroy()

mi_save_set_get_first()

mi_save_set_get_last()

mi_save_set_get_next()

mi_save_set_get_previous()

mi_save_set_insert()

mi_save_set_member()

mi_server_connect()

mi_server_reconnect()

mi_set_connection_user_data()

mi_set_default_connection_info()

mi_set_default_database_info()

mi_set_large()

mi_set_parameter_info()

mi_set_vardata()

mi_set_vardata_align()

mi_set_varlen()

mi_set_varptr()

mi_statement_command_name()

mi_string_to_date()

mi_string_to_datetime()

mi_string_to_decimal()

mi_string_to_interval()

mi_string_to_lvarchar()

mi_string_to_money()

mi_switch_mem_duration()

mi_sysname()

mi_td_cast_get()

mi_tracefile_set()

mi_tracelevel_set()

mi_transition_type()

mi_type_align()

mi_type_byvalue()

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

mi_type_typename()

mi_typedesc_typeid()

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

mi_typename_to_id()

mi_typename_to_typedesc()

mi_typestring_to_id()

mi_typestring_to_typedesc()

mi_unregister_callback()

mi_value()

mi_value_by_name()

mi_var_copy()

mi_var_free()

mi_var_to_buffer()

mi_xact_levels()

mi_xact_state()

mi_yield()

mi_zalloc()

rdatestr()

rdayofweek()

rdefmtdate()

rdownshift()

rfmtdate()

rfmtdec()

rfmtdouble()

rfmtlong()

rjulmdy()

rleapyear()

rmdyjul()

rstod()

rstoi()

rstol()

rstrdate()

rtoday()

rupshift()

stcat()

stchar()

stcmpr()

stcopy()

stleng()