Home | Previous Page | Next Page  

Contents

Introduction
In This Introduction
About This Manual
Types of Users
Software Dependencies
Assumptions About Your Locale
Demonstration Databases
New Features in Dynamic Server, Version 10.0
Features From Previous Versions
Function Syntax Conventions
DataBlade API Module Code Conventions
Documentation Conventions
Typographical Conventions
Feature, Product, and Platform Markup
Syntax Diagrams
Example Code Conventions
Additional Documentation
IBM Informix Information Center
Installation Guides
Online Notes
Informix Error Messages
Manuals
Online Help
Accessibility
IBM Informix Dynamic Server Version 10.0 and CSDK Version 2.90 Documentation Set
Compliance with Industry Standards
IBM Welcomes Your Comments
Categories of DataBlade API Functions
In This Chapter
The DataBlade API Function Library
Data Handling
Session, Thread, and Transaction Management
SQL Statement Processing
User-Defined Routine Execution
Selectivity and Cost Functions
Memory Management
Exception Handling
Smart-Large-Object Interface
Input and Output Operations
Tracing (Server)
Control of the Virtual-Processor Environment (Server)
Database Management (Client)
Miscellaneous Information
Database Server Version Information
The ESQL/C Function Library
Function Descriptions
In This Chapter
3 3
ax_reg( )
3 3
ax_unreg( )
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_call_on_vp( )
mi_cast_get( )
mi_class_id( )
mi_class_maxvps( )
mi_class_name( )
mi_class_numvp( )
mi_client( )
mi_client_locale( )
mi_close( )
mi_close_statement( )
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( )
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_convert_from_codeset( )
mi_convert_to_codeset( )
mi_current_command_name( )
mi_dalloc( )
mi_date_to_binary( )
mi_date_to_string( )
mi_datetime_to_binary( )
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_sql_state( )
mi_error_sqlcode( )
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_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_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( )
mi_fp_returnisnull( )
mi_fp_setargisnull( )
mi_fp_setarglen( )
mi_fp_setargprec( )
mi_fp_setargscale( )
mi_fp_setargtype( )
mi_fp_setcolid( )
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_setrow( )
mi_fp_usr_fparam( )
mi_fparam_allocate( )
mi_fparam_copy( )
mi_fparam_free( )
mi_fparam_get( )
mi_fparam_get_current( )
mi_free( )
mi_func_commutator( )
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_cursor_table( )
mi_get_database_info( )
mi_get_date( )
mi_get_datetime( )
mi_get_db_locale( )
mi_get_dbnames( )
mi_get_decimal( )
mi_get_default_connection_info( )
mi_get_default_database_info( )
mi_get_double_precision( )
mi_get_duration_size( )
mi_get_id( )
mi_get_int8( )
mi_get_integer( )
mi_get_interval( )
mi_get_lo_handle( )
mi_get_memptr_duration( )
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_session_connection( )
mi_get_smallint( )
mi_get_statement_row_desc( )
mi_get_string( )
mi_get_type_source_type( )
mi_get_transaction_id( )
mi_get_vardata( )
mi_get_vardata_align( )
mi_get_varlen( )
mi_hdr_status( )
mi_init_library( )
mi_interrupt_check( )
mi_interval_to_string( )
mi_issmall_data( )
mi_last_serial( )
mi_last_serial8( )
mi_library_version( )
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_flags( )
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_flags( )
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_mtime_usec( )
mi_lo_stat_refcnt( )
mi_lo_stat_size( )
mi_lo_stat_uid( )
mi_lo_tell( )
mi_lo_to_buffer( )
mi_lo_to_file( )
mi_lo_to_string( )
mi_lo_truncate( )
mi_lo_unlock( )
mi_lo_utimes( )
mi_lo_validate( )
mi_lo_write( )
mi_lo_writewithseek( )
mi_lock_memory( )
mi_lvarchar_to_string( )
mi_module_lock( )
mi_money_to_binary( )
mi_money_to_string( )
mi_named_alloc( )
mi_named_free( )
mi_named_get( )
mi_named_zalloc( )
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_process_exec( )
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_realloc( )
mi_register_callback( )
mi_result_command_name( )
mi_result_reference( )
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_library_version( )
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_stack_limit( )
mi_statement_command_name( )
mi_stream_clear_eof( )
mi_stream_close( )
mi_stream_eof( )
mi_stream_get_error( )
mi_stream_getpos( )
mi_stream_init( )
mi_stream_length( )
mi_stream_open_fio( )
mi_stream_open_mi_lvarchar( )
mi_stream_open_str( )
mi_stream_read( )
mi_stream_seek( )
mi_stream_set_eof( )
mi_stream_set_error( )
mi_stream_setpos( )
mi_stream_tell( )
mi_stream_write( )
mi_streamread_boolean( )
mi_streamread_collection( )
mi_streamread_date( )
mi_streamread_datetime( )
mi_streamread_decimal( )
mi_streamread_double( )
mi_streamread_int8( )
mi_streamread_integer( )
mi_streamread_interval( )
mi_streamread_lo( )
mi_streamread_lo_by_lofd( )
mi_streamread_lvarchar( )
mi_streamread_money( )
mi_streamread_real( )
mi_streamread_row( )
mi_streamread_smallint( )
mi_streamread_string( )
mi_streamwrite_boolean( )
mi_streamwrite_collection( )
mi_streamwrite_date( )
mi_streamwrite_datetime( )
mi_streamwrite_decimal( )
mi_streamwrite_double( )
mi_streamwrite_int8( )
mi_streamwrite_integer( )
mi_streamwrite_interval( )
mi_streamwrite_lo( )
mi_streamwrite_lvarchar( )
mi_streamwrite_money( )
mi_streamwrite_real( )
mi_streamwrite_row( )
mi_streamwrite_smallint( )
mi_streamwrite_string( )
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_system( )
mi_td_cast_get( )
mi_tracefile_set( )
mi_tracelevel_set( )
mi_transaction_state( ) (Server)
mi_transition_type( )
mi_trigger_event( )
mi_trigger_get_new_row( )
mi_trigger_get_old_row( )
mi_trigger_level( )
mi_trigger_name( )
mi_trigger_tabname( )
mi_try_lock_memory( )
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_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_udr_lock( )
mi_unlock_memory( )
mi_unregister_callback( )
mi_value( )
mi_value_by_name( )
mi_var_copy( )
mi_var_free( )
mi_var_to_buffer( )
mi_version_comparison( )
mi_vpinfo_classid( )
mi_vpinfo_isnoyield( )
mi_vpinfo_vpid( )
3 3
mi_xa_get_current_xid( )
3 3
mi_xa_get_xadatasource_rmid( )
3 3
mi_xa_register_xadatasource( )
3 3
mi_xa_unregister_xadatasource( )
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( )
Appendix. Accessibility
Dotted Decimal Syntax Diagrams
Notices
Trademarks
Index
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]