Home
Extending Informix®
Beyond standard relational database objects, HCL Informix® can be extended to handle specialized data types, access methods, routines, and other objects. Informix includes many built-in extensions that are fully integrated in the database server. Informix 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 Informix.
Creating extensions
You 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 Informix® databases.
DataBlade® API Function Reference
The Informix® DataBlade® API Function Reference describes the DataBlade API functions and the subset of Informix ESQL/C functions that the DataBlade API supports.
Function descriptions
This section gives comprehensive reference information about the functions that are valid within DataBlade® API modules. It lists the function descriptions in alphabetical order, with syntax, usage information, and return values for the functions.
The mi_system() function
The mi_system() function allows you to execute operating system commands from within a DataBlade® module or C UDR.

Extending Informix®
Beyond standard relational database objects, HCL Informix® can be extended to handle specialized data types, access methods, routines, and other objects. Informix includes many built-in extensions that are fully integrated in the database server. Informix 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 Informix.
- Informix® extensions and DataBlade® modules
  These topics describe how to use built-in database extensions and separately installed DataBlade® modules.
- Creating extensions
  You 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 Informix® databases.
  - DataBlade® API Programmer's Guide
    The Informix® DataBlade® API Programmer's Guide describes information about the DataBlade API, the C-language application programming interface (API) provided with HCL Informix.
  - DataBlade® API Function Reference
    The Informix® DataBlade® API Function Reference describes the DataBlade API functions and the subset of Informix ESQL/C functions that the DataBlade API supports.
    - Categories of DataBlade® API functions
      This 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.
    - Function descriptions
      This section gives comprehensive reference information about the functions that are valid within DataBlade® API modules. It lists the function descriptions in alphabetical order, with syntax, usage information, and return values for the functions.
      - The ax_reg() function
        The ax_reg() function allows DataBlade® modules or applications using user-defined routines (UDRs) to register XA-compliant, external data sources (also called resource managers) with the HCL Informix® transaction manager. The registration is dynamic and is applicable for the current transaction only. The DataBlade must register participating data sources into each transaction.
      - The ax_unreg() function
        The ax_unreg() function allows DataBlade® modules or applications using user-defined routines (UDRs) to unregister previously registered XA-compliant, external data sources (also called resource managers) from transactions.
      - The biginttoint2() function
        The biginttoint2() function converts a BIGINT type number to an int2 type number.
      - The bigintcvint2() function
        The bigintcvint2() function converts an int2 type number to a BIGINT type number.
      - The biginttoint4() function
        The biginttoint4() function converts a BIGINT type number to an int4 type number.
      - The bigintcvint4() function
        The bigintcvint4() function converts an int4 type number to a BIGINT type number.
      - The biginttoasc() function
        The biginttoasc() function converts a BIGINT type value to a C char type value.
      - The bigintcvasc() function
        The bigintcvasc() function converts a C char type value to a BIGINT type number.
      - The bigintcvdec() function
        The bigintcvdec() function converts a decimal type number to a BIGINT type number.
      - The biginttodec() function
        The biginttodec() function converts a BIGINT type number to a decimal type number.
      - The biginttodbl() function
        The biginttodbl() function converts a BIGINT type number to a double type number.
      - The bigintcvdbl() function
        The bigintcvdbl() function converts a double type number to a BIGINT type number.
      - The biginttoflt() function
        The biginttoflt() function converts a BIGINT type number to a float type number.
      - The bigintcvflt() function
        The bigintcvflt() function converts a float type number to a BIGINT type number.
      - The bigintcvifx_int8() function
        The bigintcvifx_int8() function converts and int8 type number to a BIGINT type number.
      - The biginttoifx_int8() function
        The biginttoifx_int8() function converts a BIGINT type number to an int8 type number.
      - The bycmpr() function
        The bycmpr() function compares two groups of contiguous bytes for a given length. This function returns the result of the comparison.
      - The bycopy() function
        The bycopy() function copies a given number of bytes from one location to another.
      - The byfill() function
        The byfill() function fills a specified area with one character.
      - The byleng() function
        The byleng() function returns the number of significant characters in a string, not counting trailing blanks.
      - The decadd() function
        The decadd() function adds two decimal type values.
      - The deccmp() function
        The deccmp() function compares two decimal type numbers.
      - The deccopy() function
        The deccopy() function copies a value from one decimal structure to another.
      - The deccvasc() function
        The deccvasc() function converts a value held as printable characters in a C char type into a decimal type number.
      - The deccvdbl() function
        The deccvdbl() function converts a C double type number into a decimal type number.
      - The deccvint() function
        The deccvint() function converts a C int type number into a decimal type number.
      - The deccvlong() function
        The deccvlong() function converts an int4 type value into a decimal type value.
      - The decdiv() function
        The decdiv() function divides two decimal type values.
      - The dececvt() and decfcvt() functions
        The dececvt() and decfcvt() functions are analogous to the subroutines under ECVT(3) in the UNIX™ Programmer's Manual.
      - The decmul() function
        The decmul() function multiplies two decimal type values.
      - The decround() function
        The decround() function rounds a decimal type number to fractional digits.
      - The decsub() function
        The decsub() function subtracts two decimal type values.
      - The dectoasc() function
        The dectoasc() function converts a decimal type number to a C char type value.
      - The dectodbl() function
        The dectodbl() function converts a decimal type number into a C double type number.
      - The dectoint() function
        The dectoint() function converts a decimal type number into a C int type number.
      - The dectolong() function
        The dectolong() function converts a decimal type number into an int4 type number.
      - The dectrunc() function
        The dectrunc() function truncates a rounded decimal type number to fractional digits.
      - The dtaddinv() function
        The dtaddinv() function adds an interval value to a datetime value. The result is a datetime value.
      - The dtcurrent() function
        The dtcurrent() function assigns the current date and time to a datetime variable.
      - The dtcvasc() function
        The dtcvasc() function converts a string that conforms to ANSI SQL standard for a DATETIME value to a datetime value.
      - The dtcvfmtasc() function
        The dtcvfmtasc() function uses a formatting mask to convert a character string to a datetime value.
      - The dtextend() function
        The dtextend() function extends a datetime value to a different qualifier. Extending is the operation of adding or dropping fields of a DATETIME value to make it match a given qualifier.
      - The dtsub() function
        The dtsub() function subtracts one datetime value from another. The result is an interval value.
      - The dtsubinv() function
        The dtsubinv() function subtracts an interval value from a datetime value. The result is a datetime value.
      - The dttoasc() function
        The dttoasc() function converts the field values of a datetime variable to an ASCII string that conforms to ANSI SQL standards.
      - The dttofmtasc() function
        The dttofmtasc() function uses a formatting mask to convert a datetime variable to a character string.
      - The ifx_int8add() function
        The ifx_int8add() function adds two int8 type values.
      - The ifx_int8cmp() function
        The ifx_int8cmp() function compares two int8 type numbers.
      - The ifx_int8copy() function
        The ifx_int8copy() function copies one int8 structure to another.
      - The ifx_int8cvasc() function
        The ifx_int8cvasc() function converts a value held as printable characters in a C char type into an int8 type number.
      - The ifx_int8cvdbl() function
        The ifx_int8cvdbl() function converts a C double type number into an int8 type number.
      - The ifx_int8cvdec() function
        The ifx_int8cvdec() function converts a decimal type value into an int8 type value.
      - The ifx_int8cvflt() function
        The ifx_int8cvflt() function converts a C float type number into an int8 type number.
      - The ifx_int8cvint() function
        The ifx_int8cvint() function converts a C int type number into an int8 type number.
      - The ifx_int8cvlong() function
        The ifx_int8cvlong() function converts a C long type value into an int8 type value.
      - The ifx_int8div() function
        The ifx_int8div() function divides two int8 type values.
      - The ifx_int8mul() function
        The ifx_int8mul() function multiplies two int8 type values.
      - The ifx_int8sub() function
        The ifx_int8sub() function subtracts two int8 type values.
      - The ifx_int8toasc() function
        The ifx_int8toasc() function converts an int8 type number to a C char type value.
      - The ifx_int8todbl() function
        The ifx_int8todbl() function converts an int8 type number into a C double type number.
      - The ifx_int8todec() function
        The ifx_int8todec() function converts an int8 type number into a decimal type number.
      - The ifx_int8toflt() function
        The ifx_int8toflt() function converts an int8 type number into a C float type number.
      - The ifx_int8toint() function
        The ifx_int8toint() function converts an int8 type number into a C int type number.
      - The ifx_int8tolong() function
        The ifx_int8tolong() function converts an int8 type number into a C long type number.
      - The incvasc() function
        The incvasc() function converts a string that conforms to the ANSI SQL standard for an INTERVAL value to an interval value.
      - The incvfmtasc() function
        The incvfmtasc() function uses a formatting mask to convert a character string to an interval value.
      - The intoasc() function
        The intoasc() function converts the field values of an interval variable to an ASCII string that conforms to the ANSI SQL standard.
      - The intofmtasc() function
        The intofmtasc() function uses a formatting mask to convert an interval variable to a character string.
      - The invdivdbl() function
        The invdivdbl() function divides an interval value by a numeric value.
      - The invdivinv() function
        The invdivinv() function divides an interval value by another interval value.
      - The invextend() function
        The invextend() function copies an interval value under a different qualifier.
      - The invmuldbl() function
        The invmuldbl() function multiplies an interval value by a numeric value.
      - The ldchar() function
        The ldchar() function copies a fixed-length string into a null-terminated string and removes any trailing blanks.
      - The mi_alloc() function
        The mi_alloc() function allocates a block of user memory of a specified size and returns a pointer to that block.
      - The mi_binary_to_date() function
        The mi_binary_to_date() function creates a text (string) representation of a date from the internal (binary) DATE representation.
      - The mi_binary_to_datetime() function
        The mi_binary_to_datetime() function creates a text (string) representation of a date, time, or date and time value from the binary DATETIME representation.
      - The mi_binary_to_decimal() function
        The mi_binary_to_decimal() function creates a text (string) representation of a decimal value from the internal (binary) DECIMAL representation.
      - The mi_binary_to_money() function
        The mi_binary_to_money() function creates a text (string) representation of a monetary value from the internal (binary) MONEY representation.
      - The mi_binary_query() function
        The mi_binary_query() function reports whether the last SQL statement sent on a particular connection returns results in a binary representation.
      - The mi_call() function
        The mi_call() function checks if there is sufficient stack space for the specified user-defined routine and extends the stack size if necessary.
      - The mi_call_on_vp() function
        The mi_call_on_vp() function enables you to switch execution to a specified virtual processor (VP) to execute a specified C function.
      - The mi_cast_get() function
        The mi_cast_get() function looks up a registered cast function by the type identifiers of its source and target data types and creates its function descriptor.
      - The mi_class_id() function
        The mi_class_id() function obtains the VP-class identifier for a specified virtual-processor (VP) class.
      - The mi_class_maxvps() function
        The mi_class_maxvps() function obtains the maximum number of virtual processors (VPs) in a VP class.
      - The mi_class_name() function
        The mi_class_name() function obtains the name of a virtual-processor (VP) class.
      - The mi_class_numvp() function
        The mi_class_numvp() function obtains the number of active virtual processors (VPs) in a VP class.
      - The mi_client() function
        The mi_client() function dynamically determines whether a DataBlade® API module is running in the database server or as a client application.
      - The mi_client_locale() function
        The mi_client_locale() function returns the name of the client locale.
      - The mi_close() function
        The mi_close() function closes a connection.
      - The mi_close_statement() function
        The mi_close_statement() function closes an open cursor.
      - The mi_collection_card() function
        The mi_collection_card() function returns a count of the elements in a collection (that is, its cardinality).
      - The mi_collection_close() function
        The mi_collection_close() function closes a collection and frees the collection descriptor.
      - The mi_collection_copy() function
        The mi_collection_copy() function copies a collection to a new collection variable.
      - The mi_collection_create() function
        The mi_collection_create() function creates a collection.
      - The mi_collection_delete() function
        The mi_collection_delete() function deletes a single element of a collection.
      - The mi_collection_fetch() function
        The mi_collection_fetch() function fetches a single element from a collection.
      - The mi_collection_free() function
        The mi_collection_free() function frees a collection.
      - The mi_collection_insert() function
        The mi_collection_insert() function inserts a single element into a collection.
      - The mi_collection_open() function
        The mi_collection_open() function opens a collection.
      - The mi_collection_open_with_options() function
        The mi_collection_open_with_options() function opens a collection in a specified open mode.
      - The mi_collection_update() function
        The mi_collection_update() function updates a collection.
      - The mi_column_count() function
        The mi_column_count() function obtains the number of columns in a row descriptor.
      - The mi_column_default() function
        The mi_column_default() function retrieves the default value of the specified column.
      - The mi_column_default_string() function
        The mi_column_default_string() function retrieves the default value of the specified column in string format.
      - The mi_column_id() function
        The mi_column_id() function obtains the column identifier of a specified column from a row descriptor.
      - The mi_column_name() function
        The mi_column_name() function obtains the name of a specified column from a row descriptor.
      - The mi_column_nullable() function
        The mi_column_nullable() function indicates whether a specified column in a row descriptor can contain SQL NULL values.
      - The mi_column_precision() function
        The mi_column_precision() function obtains the precision of the specified column from a row descriptor.
      - The mi_column_scale() function
        The mi_column_scale() function obtains the scale of the specified column from a row descriptor.
      - The mi_column_type_id() function
        The mi_column_type_id() function obtains the type identifier of the specified column from a row descriptor.
      - The mi_column_typedesc() function
        The mi_column_typedesc() function obtains the type descriptor of the specified column from a row descriptor.
      - The mi_command_is_finished() function
        The mi_command_is_finished() function reports whether the current statement has finished executing.
      - The mi_current_command_name() function
        The mi_current_command_name() function returns the name of the SQL statement that invoked the C UDR.
      - The mi_dalloc() function
        The mi_dalloc() function allocates the specified amount of memory for the specified memory duration and returns a pointer to the allocated block.
      - The mi_date_to_binary() function
        The mi_date_to_binary() function converts a text (string) representation of a date value to its binary (internal) DATE representation.
      - The mi_date_to_string() function
        The mi_date_to_string() function creates a text (string) representation of a date value from the binary (internal) DATE representation.
      - The mi_datetime_compare() function
        The mi_datetime_compare() function compares two binary (internal) DATETIME values and returns an integer value that indicates whether the first value is before, equal to, or after the second value.
      - The mi_datetime_to_binary() function
        The mi_datetime_to_binary() function converts a text (string) representation of a date, time, or date and time value to its binary (internal) DATETIME representation.
      - The mi_datetime_to_string() function
        The mi_datetime_to_string() function creates an ANSI SQL standard text (string) representation of a date, time, or date and time value from the binary (internal) DATETIME representation.
      - The mi_db_error_raise() function
        The mi_db_error_raise() function raises an error or warning and sends the message to the calling program.
      - The mi_dbcreate() function
        The mi_dbcreate() function creates a new database on the given connection.
      - The mi_dbdrop() function
        The mi_dbdrop() function drops a database from the given connection.
      - The mi_decimal_to_binary() function
        The mi_decimal_to_binary() function converts a text (string) representation of a decimal value to its binary (internal) DECIMAL representation.
      - The mi_decimal_to_string() function
        The mi_decimal_to_string() function creates a text (string) representation of a decimal value from the binary (internal) DECIMAL representation.
      - The mi_default_callback() function
        The mi_default_callback() function is the system-default callback for all callbacks in a client LIBMI application.
      - The mi_disable_callback() function
        The mi_disable_callback() function disables a callback for a single event or for all events.
      - The mi_drop_prepared_statement() function
        The mi_drop_prepared_statement() function drops a previously prepared statement.
      - The mi_enable_callback() function
        The mi_enable_callback() function enables a callback for a specified event type.
      - The mi_errmsg() function
        The mi_errmsg() function retrieves an error or warning message from an error descriptor into a user-allocated buffer.
      - The mi_error_desc_copy() function
        The mi_error_desc_copy() function returns a copy of a specified error descriptor.
      - The mi_error_desc_destroy() function
        The mi_error_desc_destroy() function frees an error descriptor that the mi_error_desc_copy() function allocated.
      - The mi_error_desc_finish() function
        The mi_error_desc_finish() function completes processing of the current exception list.
      - The mi_error_desc_is_copy() function
        The mi_error_desc_is_copy() function determines whether the specified error descriptor is a user copy.
      - The mi_error_desc_next() function
        The mi_error_desc_next() function gets the next error descriptor from the list of current exceptions that are associated with the current SQL statement.
      - The mi_error_level() function
        The mi_error_level() function retrieves from an error descriptor the exception level associated with an exception or an error level associated with a client LIBMI error.
      - The mi_error_sql_state() function
        The mi_error_sql_state() function retrieves the value of the SQLSTATE status variable from an error descriptor.
      - The mi_error_sqlcode() function
        The mi_error_sqlcode() function retrieves the value of the HCL Informix® SQLCODE status variable from an error descriptor.
      - The mi_exec() function
        The mi_exec() function sends an SQL statement to the database server for parsing, optimization, and execution.
      - The mi_exec_prepared_statement() function
        The mi_exec_prepared_statement() function sends a prepared statement to the database server for execution.
      - The mi_fetch_statement() function
        The mi_fetch_statement() function fetches specified rows from the database server into a cursor that is associated with an opened prepared statement.
      - The mi_file_allocate() function
        The mi_file_allocate() function ensures that a specified number of files are available to be opened.
      - The mi_file_close() function
        The mi_file_close() function closes an operating-system file.
      - The mi_file_errno() function
        The mi_file_errno() function returns the value of the system errno variable after a file input/output (I/O) operation. This value is the last errno value generated during an mi_file* function call and comes from the computer where the file is located. This function does not translate the value from one platform to another.
      - The mi_file_open() function
        The mi_file_open() function opens an operating-system file.
      - The mi_file_read() function
        The mi_file_read() function reads a specified number of bytes from an open operating-system file into a buffer.
      - The mi_file_seek() function
        The mi_file_seek() function sets the file seek position for the next read or write operation on the open file.
      - The mi_file_seek8() function
        The mi_file_seek8() function sets the file seek position for the next read or write operation on an open file of length greater that 2 GB.
      - The mi_file_sync() function
        The mi_file_sync() function forces a write to disk of all pages in an operating-system file.
      - The mi_file_tell() function
        The mi_file_tell() function returns the current file seek position for an operating-system file, relative to the beginning of the file.
      - The mi_file_tell8() function
        The mi_file_tell8() function returns the current file seek position, relative to the beginning of the file, for an operating-system file of length greater than 2 GB.
      - The mi_file_to_file() function
        The mi_file_to_file() function copies files between the database server and a client computer.
      - The mi_file_unlink() function
        The mi_file_unlink() function unlinks (removes) a file that mi_file_open() previously opened.
      - The mi_file_write() function
        The mi_file_write() function writes a specified number of bytes to an open operating-system file.
      - The mi_fix_integer() function
        The mi_fix_integer() function converts the specified 4-byte integer to or from the byte order of the client computer.
      - The mi_fix_smallint() function
        The mi_fix_smallint() function converts the specified 2-byte integer to or from the byte order of the client computer.
      - The mi_fp_argisnull() function
        The mi_fp_argisnull() accessor function determines whether the argument of a user-defined routine is an SQL NULL value from its associated MI_FPARAM structure.
      - The mi_fp_arglen() function
        The mi_fp_arglen() accessor function obtains the length of an argument of a user-defined routine from its associated MI_FPARAM structure.
      - The mi_fp_argprec() function
        The mi_fp_argprec() accessor function obtains the precision of an argument of a user-defined routine from its associated MI_FPARAM structure.
      - The mi_fp_argscale() function
        The mi_fp_argscale() accessor function obtains the scale of an argument of a user-defined routine from its associated MI_FPARAM structure.
      - The mi_fp_argtype() function
        The mi_fp_argtype() accessor function obtains the type identifier for the data type of an argument of a user-defined routine from the argument's associated MI_FPARAM structure.
      - The mi_fp_funcname() function
        The mi_fp_funcname() function obtains the name of a user-defined routine (UDR) using its associated MI_FPARAM structure.
      - The mi_fp_funcstate() function
        The mi_fp_funcstate() accessor function obtains user-state information for the user-defined routine from its associated MI_FPARAM structure.
      - The mi_fp_getcolid() function
        The mi_fp_getcolid() accessor function obtains the column identifier of the column that is associated with the user-defined routine from its MI_FPARAM structure.
      - The mi_fp_getfuncid() function
        The mi_fp_getfuncid() accessor function obtains the routine identifier for a user-defined routine (UDR) in its associated MI_FPARAM structure.
      - The mi_fp_getrow() function
        The mi_fp_getrow() accessor function obtains the row structure that is associated with the user-defined routine from its MI_FPARAM structure.
      - The mi_fp_nargs() function
        The mi_fp_nargs() accessor function obtains the number of arguments for the UDR routine from its associated MI_FPARAM structure.
      - The mi_fp_nrets() function
        The mi_fp_nrets() accessor function obtains the number of return values for the UDR from its associated MI_FPARAM structure.
      - The mi_fp_request() function
        The mi_fp_request() accessor function obtains the iterator status for an iterator function from an associated MI_FPARAM structure.
      - The mi_fp_retlen() function
        The mi_fp_retlen() accessor function obtains the length of a return value of a user-defined function from its associated MI_FPARAM structure.
      - The mi_fp_retprec() function
        The mi_fp_retprec() accessor function obtains the precision of a return value of a user-defined function from its associated MI_FPARAM structure.
      - The mi_fp_retscale() function
        The mi_fp_retscale() accessor function obtains the scale of a return value of a user-defined function from its associated MI_FPARAM structure.
      - The mi_fp_rettype() function
        The mi_fp_rettype() accessor function obtains the type identifier for the data type of a return value of a user-defined function from its associated MI_FPARAM structure.
      - The mi_fp_returnisnull() function
        The mi_fp_returnisnull() accessor function determines whether the return value of a user-defined function is an SQL NULL from its associated MI_FPARAM structure.
      - The mi_fp_setargisnull() function
        The mi_fp_setargisnull() accessor function sets the value of an argument of a user-defined routine to an SQL NULL in its associated MI_FPARAM structure.
      - The mi_fp_setarglen() function
        The mi_fp_setarglen() accessor function sets the length of an argument of a user-defined routine in its associated MI_FPARAM structure.
      - The mi_fp_setargprec() function
        The mi_fp_setargprec() accessor function sets the precision of a fixed-point or floating-point argument of a user-defined routine in its associated MI_FPARAM structure.
      - The mi_fp_setargscale() function
        The mi_fp_setargscale() accessor function sets the scale of an argument of a user-defined routine in its associated MI_FPARAM structure.
      - The mi_fp_setargtype() function
        The mi_fp_setargtype() accessor routine sets the type identifier for the data type of an argument of a user-defined routine in its associated MI_FPARAM structure.
      - The mi_fp_setcolid() function
        The mi_fp_setcolid() accessor function sets the column identifier of the column that is associated with the user-defined routine from its MI_FPARAM structure.
      - The mi_fp_setfuncid() function
        The mi_fp_setfuncid() accessor function sets the routine identifier for a user-defined routine in its associated MI_FPARAM structure.
      - The mi_fp_setfuncstate() function
        The mi_fp_setfuncstate() accessor function sets the user-state pointer for the user-defined routine in its associated MI_FPARAM structure.
      - The mi_fp_setisdone() function
        The mi_fp_setisdone() accessor function sets the iterator-completion flag for an iterator function in its associated MI_FPARAM structure.
      - The mi_fp_setnargs() function
        The mi_fp_setnargs() accessor function sets the number of arguments for the user-defined routine in its associated MI_FPARAM structure.
      - The mi_fp_setnrets() function
        The mi_fp_setnrets() accessor function sets the number of return values for the user-defined function in its associated MI_FPARAM structure.
      - The mi_fp_setretlen() function
        The mi_fp_setretlen() accessor function sets the length of a return value of a user-defined function from its associated MI_FPARAM structure.
      - The mi_fp_setretprec() function
        The mi_fp_setretprec() accessor function sets the precision of a return value of a user-defined function in its associated MI_FPARAM structure.
      - The mi_fp_setretscale() function
        The mi_fp_setretscale() accessor function sets the scale of a return value of a user-defined function in its associated MI_FPARAM structure.
      - The mi_fp_setrettype() function
        The mi_fp_setrettype() accessor function sets the type identifier for the data type of a return value of a user-defined function in its associated MI_FPARAM structure.
      - The mi_fp_setreturnisnull() function
        The mi_fp_setreturnisnull() accessor function sets the value of a return value of a user-defined function to an SQL NULL in its associated MI_FPARAM structure.
      - The mi_fp_setrow() function
        The mi_fp_setrow() accessor function sets the row structure that is associated with the user-defined routine in its associated MI_FPARAM structure.
      - The mi_fp_usr_fparam() function
        The mi_fp_usr_fparam() accessor function determines whether the database server or the developer has allocated the specified MI_FPARAM structure.
      - The mi_fparam_allocate() function
        The mi_fparam_allocate() function allocates an MI_FPARAM structure and returns a pointer to this structure.
      - The mi_fparam_copy() function
        The mi_fparam_copy() function copies an existing MI_FPARAM structure to a newly allocated MI_FPARAM structure field by field.
      - The mi_fparam_free() function
        The mi_fparam_free() function deallocates resources used by an MI_FPARAM structure allocated on behalf of a user-defined routine.
      - The mi_fparam_get() function
        The mi_fparam_get() function retrieves a pointer to the MI_FPARAM structure that is associated with the function descriptor of a user-defined routine.
      - The mi_fparam_get_current() function
        The mi_fparam_get_current() function obtains the MI_FPARAM structure for the currently running user-defined routine (UDR).
      - The mi_free() function
        The mi_free() routine frees the user memory that was previously allocated with the mi_alloc(), mi_dalloc(), or mi_zalloc() function.
      - The mi_func_commutator() function
        The mi_func_commutator() function obtains the name of a commutator function for a user-defined function.
      - The mi_func_desc_by_typeid() function
        The mi_func_desc_by_typeid() function looks up a registered user-defined routine by its routine identifier and creates its function descriptor.
      - The mi_func_handlesnulls() function
        The mi_func_handlesnulls() function determines whether a user-defined routine (UDR) can handle SQL NULL values.
      - The mi_func_isvariant() function
        The mi_func_isvariant() function determines whether a user-defined function is variant.
      - The mi_func_negator() function
        The mi_func_negator() function obtains the name of a negator function for a user-defined function.
      - The mi_funcarg_get_argtype() function
        The mi_funcarg_get_argtype() function returns the argument type for the companion-UDR argument of a cost or selectivity function.
      - The mi_funcarg_get_colno() function
        The mi_funcarg_get_colno() function returns the column number for the column associated with the companion-UDR argument of a cost or selectivity function.
      - The mi_funcarg_get_constant() function
        The mi_funcarg_get_constant() function returns the constant value of a companion-UDR argument of a cost or selectivity function.
      - The mi_funcarg_get_datalen() function
        The mi_funcarg_get_datalen() function returns the data length of an argument for the companion UDR of a cost or selectivity function.
      - The mi_funcarg_get_datatype() function
        The mi_funcarg_get_datatype() function returns the type identifier for the data type of an argument for the companion UDR of a cost or selectivity function.
      - The mi_funcarg_get_distrib() function
        The mi_funcarg_get_distrib() function returns the data-distribution information for the column associated with the companion-UDR argument of a cost or selectivity function.
      - The mi_funcarg_get_routine_id() function
        The mi_funcarg_get_routine_id() function returns the routine identifier for the companion UDR of a cost or selectivity function.
      - The mi_funcarg_get_routine_name() function
        The mi_funcarg_get_routine_name() function returns the routine name for the companion UDR of a cost or selectivity function.
      - The mi_funcarg_get_tabid() function
        The mi_funcarg_get_tabid() function returns the table identifier for the column associated with the companion-UDR argument of a cost or selectivity function.
      - The mi_funcarg_isnull() function
        The mi_funcarg_isnull() function determines whether the companion-UDR argument of a cost or selectivity function contains the SQL NULL value.
      - The mi_get_bigint() function
        The mi_get_bigint() function copies an mi_bigint (BIGINT) value, converting any difference in alignment or byte order on the client computer to that of the server computer.
      - The mi_get_bytes() function
        The mi_get_bytes() function copies the given number of bytes, converting any difference in alignment or byte order on the client computer to that of the server computer.
      - The mi_get_connection_info() function
        The mi_get_connection_info() function populates a connection-information descriptor with current connection parameters for an open connection.
      - The mi_get_connection_option() function
        The mi_get_connection_option() function returns information about the database of the current connection.
      - The mi_get_connection_user_data() function
        The mi_get_connection_user_data() function obtains the address of user data associated with an open connection.
      - The mi_get_cursor_table() function
        The mi_get_cursor_table() function obtains the name of the database table that is associated with a specified cursor.
      - The mi_get_database_info() function
        The mi_get_database_info() function populates a database-information descriptor with current database parameters for an open connection.
      - The mi_get_date() function
        The mi_get_date() function copies an mi_date (DATE) value, converting any difference in alignment or byte order on the client computer to that of the server computer.
      - The mi_get_datetime() function
        The mi_get_datetime() function copies an mi_datetime (DATETIME) value, converting any difference in alignment or byte order on the client computer to that of the server computer.
      - The mi_get_db_locale() function
        The mi_get_db_locale() function returns the value of the current database locale.
      - The mi_get_dbnames() function
        The mi_get_dbnames() function retrieves the names of all databases available on the database server, corresponding to the logged-in connection.
      - The mi_get_decimal() function
        The mi_get_decimal() function copies an mi_decimal (DECIMAL) value, converting any difference in alignment or byte order on the client computer to that of the server computer.
      - The mi_get_default_connection_info() function
        The mi_get_default_connection_info() function populates a connection-information descriptor with the default connection parameters.
      - The mi_get_default_database_info() function
        The mi_get_default_database_info() function populates a database-information descriptor with the default database parameters.
      - The mi_get_double_precision() function
        The mi_get_double_precision() function copies an mi_double_precision (FLOAT) value, converting any difference in alignment or byte order on the client computer to that of the server computer.
      - The mi_get_duration_size() function
        The mi_get_duration_size() function returns the TOTAL pool size of the specified memory duration.
      - The mi_get_id() function
        The mi_get_id() function enables you to obtain statement identifiers or session identifiers.
      - The mi_get_int8() function
        The mi_get_int8() function copies an mi_int8 (INT8) value, converting any difference in alignment or byte order on the client computer to that of the server computer.
      - The mi_get_integer() function
        The mi_get_integer() function copies an mi_integer (INTEGER) value, converting any difference in alignment or byte order on the client computer to that of the server computer.
      - The mi_get_interval() function
        The mi_get_interval() function copies an mi_interval (INTERVAL) value, converting any difference in alignment or byte order on the client computer to that of the server computer.
      - The mi_get_lo_handle() function
        The mi_get_lo_handle() function copies an LO handle, converting any difference in alignment or byte order on the client computer to that of the server computer.
      - The mi_get_memptr_duration() function
        The mi_get_memptr_duration() function returns the memory duration of a specified pointer.
      - The mi_get_money() function
        The mi_get_money() function copies an mi_money (MONEY) value, converting any difference in alignment or byte order on the client computer to that of the server computer.
      - The mi_get_next_sysname() function
        The mi_get_next_sysname() function retrieves the next database server name.
      - The mi_get_parameter_info() function
        The mi_get_parameter_info() function populates a parameter-information descriptor with the current session parameters.
      - The mi_get_real() function
        The mi_get_real() function copies an mi_real (SMALLFLOAT) value, converting any difference in alignment or byte order on the client computer to that of the server computer.
      - The mi_get_result() function
        The mi_get_result() function returns the status of the current statement.
      - The mi_get_row_desc() function
        The mi_get_row_desc() function obtains a pointer to the row descriptor for the specified row.
      - The mi_get_row_desc_from_type_desc() function
        The mi_get_row_desc_from_type_desc() function obtains a row descriptor that is associated with the specified type descriptor.
      - The mi_get_row_desc_without_row() function
        The mi_get_row_desc_without_row() function obtains the row descriptor for the current statement.
      - The mi_get_serverenv() function
        The mi_get_serverenv() function obtains information from the server environment.
      - The mi_get_session_connection() function
        The mi_get_session_connection() function obtains a session-duration connection descriptor.
      - The mi_get_smallint() function
        The mi_get_smallint() function copies an mi_smallint (SMALLINT) value, converting any difference in alignment or byte order on the client computer to that of the server computer.
      - The mi_get_statement_row_desc() function
        The mi_get_statement_row_desc() function obtains the row descriptor for a prepared statement.
      - The mi_get_string() function
        The mi_get_string() function copies an mi_string (CHAR(x)) value from a buffer.
      - The mi_get_type_source_type() function
        The mi_get_type_source_type() function obtains a type descriptor for the source of a distinct type.
      - The mi_get_transaction_id() function
        The mi_get_transaction_id() function obtains the current internal transaction ID.
      - The mi_get_vardata() function
        The mi_get_vardata() accessor function returns a pointer to the data contained in a varying-length structure (such as mi_lvarchar).
      - The mi_get_vardata_align() function
        The mi_get_vardata_align() accessor function obtains a pointer to the data in a varying-length structure (such as mi_lvarchar) and adjusts for any initial padding required to align the data.
      - The mi_get_varlen() function
        The mi_get_varlen() accessor function returns the length of the data stored in a varying-length structure (such as mi_lvarchar).
      - The mi_hdr_status() function
        The mi_hdr_status() function returns the high-availability cluster replication status of the current server.
      - The mi_init_library() function
        The mi_init_library() function initializes the DataBlade® API library.
      - The mi_interrupt_check() function
        The mi_interrupt_check() function checks for a user interrupt.
      - The mi_interval_compare() function
        The mi_interval_compare() function compares two binary (internal) INTERVAL values and returns an integer value that indicates whether the first value is before, equal to, or after the second value.
      - The mi_interval_to_string() function
        The mi_interval_to_string() function creates an ANSI SQL standards text (string) representation of an interval value from its binary (internal) INTERVAL representation.
      - The mi_issmall_data() function
        The mi_issmall_data() macro determines whether storage of data is or is not in a smart large object.
      - The mi_last_serial() function
        The mi_last_serial() function returns a SERIAL value that the database server has generated for the most recent INSERT statement on a SERIAL column.
      - The mi_last_serial8() function
        The mi_last_serial8() function obtains the SERIAL8 value that the database server generated for the most recent INSERT statement on a SERIAL8 column.
      - The mi_library_version() function
        The mi_library_version() function returns the version and version date of the DataBlade® API currently being used.
      - The mi_lo_alter() function
        The mi_lo_alter() function alters the storage characteristics of an existing smart large object.
      - The mi_lo_close() function
        The mi_lo_close() function closes an open smart large object.
      - The mi_lo_colinfo_by_ids() function
        The mi_lo_colinfo_by_ids() function sets the fields of an LO-specification structure to the column-level storage characteristics for specified row descriptor and column identifier.
      - The mi_lo_colinfo_by_name() function
        The mi_lo_colinfo_by_name() function sets the fields of an LO-specification structure to the column-level storage characteristics for a specified database column.
      - The mi_lo_copy() function
        The mi_lo_copy() function creates a copy of a smart large object and opens the copy.
      - The mi_lo_create() function
        The mi_lo_create() function creates a new smart large object and opens it for access within a DataBlade® API module.
      - The mi_lo_decrefcount() function
        The mi_lo_decrefcount() function decrements the reference count of a smart large object.
      - The mi_lo_delete_immediate() function
        The mi_lo_delete_immediate() function deletes a smart large object.
      - The mi_lo_expand() function
        The mi_lo_expand() function copies multirepresentational data to a new smart large object.
      - The mi_lo_filename() function
        The mi_lo_filename() function constructs a file name for smart-large-object data based on an LO handle and a file name specification.
      - The mi_lo_from_buffer() function
        The mi_lo_from_buffer() function copies a specified number of bytes from a user-defined buffer to an existing smart large object.
      - The mi_lo_from_file() function
        The mi_lo_from_file() function copies the contents of an operating-system file on the server or client computer to a new smart large object.
      - The mi_lo_from_file_by_lofd() function
        The mi_lo_from_file_by_lofd() function copies the contents of an operating-system file on the server or client computer to an open smart large object.
      - The mi_lo_from_string() function
        The mi_lo_from_string() function converts an LO handle in its text representation to its binary representation.
      - The mi_lo_increfcount() function
        The mi_lo_increfcount() function increments the reference count of a smart large object.
      - The mi_lo_invalidate() function
        The mi_lo_invalidate() function marks the LO handle as invalid.
      - The mi_lo_lock() function
        The mi_lo_lock() function obtains a byte-range lock on the specified number of bytes in a smart large object.
      - The mi_lo_lolist_create() function
        The mi_lo_lolist_create() function converts an array of LO handles into an MI_LO_LIST structure.
      - The mi_lo_open() function
        The mi_lo_open() function opens an existing smart large object for access.
      - The mi_lo_ptr_cmp() function
        The mi_lo_ptr_cmp() function compares two LO handles to determine if they reference the same smart large object.
      - The mi_lo_read() function
        The mi_lo_read() function reads a specified number of bytes of data from an open smart large object into a buffer.
      - The mi_lo_readwithseek() function
        The mi_lo_readwithseek() function performs a seek operation and then reads a specified number of bytes of data from an open smart large object.
      - The mi_lo_release() function
        The mi_lo_release() function tells the database server that the resources that are associated with a temporary smart large object can be released.
      - The mi_lo_seek() function
        The mi_lo_seek() function sets the LO seek position for the next read or write operation on an open smart large object.
      - The mi_lo_spec_free() function
        The mi_lo_spec_free() function frees an LO-specification structure.
      - The mi_lo_spec_init() function
        The mi_lo_spec_init() function allocates and initializes the default system storage characteristics that are used to create a smart large object.
      - The mi_lo_specget_def_open_flags() function
        The mi_lo_specget_def_open_flags() function obtains from an LO-specification structure the default open-mode flag for a smart large object.
      - The mi_lo_specget_estbytes() function
        The mi_lo_specget_estbytes() function obtains from an LO-specification structure the estimated size, in bytes, of a smart large object.
      - The mi_lo_specget_extsz() function
        The mi_lo_specget_extsz() function obtains from an LO-specification structure the allocation extent size, in kilobytes, of a smart large object.
      - The mi_lo_specget_flags() function
        The mi_lo_specget_flags() function obtains from an LO-specification structure the attributes flag for a smart large object.
      - The mi_lo_specget_maxbytes() function
        The mi_lo_specget_maxbytes() accessor function obtains the maximum size of a smart large object (in bytes) from an LO-specification structure.
      - The mi_lo_specget_sbspace() function
        The mi_lo_specget_sbspace() function obtains from an LO-specification structure the name of an sbspace where a smart large object is stored.
      - The mi_lo_specset_def_open_flags() function
        The mi_lo_specset_def_open_flags() function sets the default open-mode flag for a smart large object.
      - The mi_lo_specset_estbytes() function
        The mi_lo_specset_estbytes() function sets the estimated size of a smart large object.
      - The mi_lo_specset_extsz() function
        The mi_lo_specset_extsz() function sets the allocation extent size for a smart large object.
      - The mi_lo_specset_flags() function
        The mi_lo_specset_flags() function sets the attributes flag for a smart large object.
      - The mi_lo_specset_maxbytes() function
        The mi_lo_specset_maxbytes() function sets the maximum number of bytes allowed for a smart large object.
      - The mi_lo_specset_sbspace() function
        The mi_lo_specset_sbspace() function sets the sbspace name of a smart large object in an LO-specification structure.
      - The mi_lo_stat() function
        The mi_lo_stat() function puts information about the current status of an open smart large object into an LO-status structure.
      - The mi_lo_stat_atime() function
        The mi_lo_stat_atime() function returns from an LO-status structure the last-access time for a smart large object.
      - The mi_lo_stat_cspec() function
        The mi_lo_stat_cspec() function returns from an LO-status structure the storage characteristics for a smart large object.
      - The mi_lo_stat_ctime() function
        The mi_lo_stat_ctime() function returns from an LO-status structure the last-change time for a smart large object.
      - The mi_lo_stat_free() function
        The mi_lo_stat_free() function frees an LO-status structure.
      - The mi_lo_stat_mtime_sec() function
        The mi_lo_stat_mtime_sec() function returns from an LO-status structure the last-modification time, in seconds, of a smart large object.
      - The mi_lo_stat_mtime_usec() function
        The mi_lo_stat_mtime_usec() function returns from an LO-status structure the microsecond component of the last-modification time for a smart large object.
      - The mi_lo_stat_refcnt() function
        The mi_lo_stat_refcnt() function returns from an LO-status structure the reference count of a smart large object.
      - The mi_lo_stat_size() function
        The mi_lo_stat_size() function obtains from an LO-status structure the size, in bytes, of a smart large object.
      - The mi_lo_stat_uid() function
        The mi_lo_stat_uid() function returns from an LO-status structure the user identifier of the owner of a smart large object.
      - The mi_lo_tell() function
        The mi_lo_tell() function returns the current LO seek position for an open smart large object, relative to the beginning of the smart large object.
      - The mi_lo_to_buffer() function
        The mi_lo_to_buffer() function copies a specified number of bytes from a smart large object to a user-defined buffer.
      - The mi_lo_to_file() function
        The mi_lo_to_file() function copies a smart large object to an operating-system file on the client or server computer.
      - The mi_lo_to_string() function
        The mi_lo_to_string() function converts an LO handle in binary representation to its text representation.
      - The mi_lo_truncate() function
        The mi_lo_truncate() function truncates a smart large object at a specified byte position.
      - The mi_lo_unlock() function
        The mi_lo_unlock() releases a byte-range lock on a smart large object.
      - The mi_lo_utimes() function
        The mi_lo_utimes() function enables you to set the last-access and last-modification time of a smart large object.
      - The mi_lo_validate() function
        The mi_lo_validate() function checks whether a given LO handle is valid.
      - The mi_lo_write() function
        The mi_lo_write() function writes a specified number of bytes to an open smart large object.
      - The mi_lo_writewithseek() function
        The mi_lo_writewithseek() function performs a seek operation and then writes a specified number of bytes of data to an open smart large object.
      - The mi_lock_memory() function
        The mi_lock_memory() function locks and waits for a named-memory mutex specified by name and duration.
      - The mi_lvarchar_to_string() function
        The mi_lvarchar_to_string() function returns the data in a varying-length structure as a null-terminated string.
      - The mi_module_lock() function
        The mi_module_lock() function prevents the shared-object file of the current UDR from being unloaded.
      - The mi_money_to_binary() function
        The mi_money_to_binary() function converts a text (string) representation of a monetary value to its binary (internal) MONEY representation.
      - The mi_money_to_string() function
        The mi_money_to_string() function creates a text (string) representation of a monetary value from the binary (internal) MONEY representation.
      - The mi_named_alloc() function
        The mi_named_alloc() function allocates a named block of memory of the specified size in the specified memory duration.
      - The mi_named_free() function
        The mi_named_free() function frees a block of named memory.
      - The mi_named_get() function
        The mi_named_get() function retrieves the address of a named-memory block.
      - The mi_named_zalloc() function
        The mi_named_zalloc() function allocates and initializes a named-memory block in the specified memory duration.
      - The mi_new_var() function
        The mi_new_var() function creates a new varying-length structure for text data.
      - The mi_next_row() function
        The mi_next_row() function retrieves the next row from the cursor of a query.
      - The mi_open() function
        The mi_open() function establishes a connection to a database server.
      - The mi_open_prepared_statement() function
        The mi_open_prepared_statement() function sends a prepared statement that is a query to the database server for execution and opens a cursor for the retrieved rows of the query.
      - The mi_parameter_count() function
        The mi_parameter_count() function returns the number of input parameters in a prepared statement.
      - The mi_parameter_nullable() function
        The mi_parameter_nullable() function indicates whether the column associated with a specified input parameter in a prepared statement can contain an SQL NULL value.
      - The mi_parameter_precision() function
        The mi_parameter_precision() function obtains the precision of the column associated with the specified input parameter in a prepared statement.
      - The mi_parameter_scale() function
        The mi_parameter_scale() function returns the scale of the column that is associated with a specified input parameter in a prepared statement.
      - The mi_parameter_type_id() function
        The mi_parameter_type_id() function returns the type identifier of the column that is associated with the specified input parameter in a prepared statement.
      - The mi_parameter_type_name() function
        The mi_parameter_type_name() function returns the data type name of the column that is associated with a specified input parameter in a prepared statement.
      - The mi_prepare() function
        The mi_prepare() function sends an SQL statement to the database server to be prepared and returns a statement descriptor for the prepared statement.
      - The mi_process_exec() function
        The mi_process_exec() function forks and executes a new process, returning before this new process completes.
      - The mi_put_bigint() function
        The mi_put_bigint() function copies an mi_bigint (BIGINT) value, converting any difference in alignment or byte order on the server computer to that of the client computer.
      - The mi_put_bytes() function
        The mi_put_bytes() function copies the given number of bytes, converting any difference in alignment or byte order on the server computer to that of the client computer.
      - The mi_put_date() function
        The mi_put_date() function copies an mi_date (DATE) value, converting any difference in alignment or byte order on the server computer to that of the client computer.
      - The mi_put_datetime() function
        The mi_put_datetime() function copies an mi_datetime (DATETIME) value, converting any difference in alignment or byte order on the server computer to that of the client computer.
      - The mi_put_decimal() function
        The mi_put_decimal() function copies an mi_decimal (DECIMAL) value, converting any difference in alignment or byte order on the server computer to that of the client computer.
      - The mi_put_double_precision() function
        The mi_put_double_precision() function copies an mi_double_precision (FLOAT) value, converting any difference in alignment or byte order on the server computer to that of the client computer.
      - The mi_put_int8() function
        The mi_put_int8() function copies an mi_int8 (INT8) value, converting any difference in alignment or byte order on the server computer to that of the client computer.
      - The mi_put_integer() function
        The mi_put_integer() function copies an mi_integer (INTEGER) value, converting any difference in alignment or byte order on the server computer to that of the client computer.
      - The mi_put_interval() function
        The mi_put_interval() function copies an mi_interval (INTERVAL) value, converting any difference in alignment or byte order on the server computer to that of the client computer.
      - The mi_put_lo_handle() function
        The mi_put_lo_handle() function copies an LO handle, converting any difference in alignment or byte order on the server computer to that of the client computer.
      - The mi_put_money() function
        The mi_put_money() function copies an mi_money (MONEY) value, converting any difference in alignment or byte order on the server computer to that of the client computer.
      - The mi_put_real() function
        The mi_put_real() function copies an mi_real (SMALLFLOAT) value, converting any difference in alignment or byte order on the server computer to that of the client computer.
      - The mi_put_smallint() function
        The mi_put_smallint() function copies an mi_smallint (SMALLINT) value, converting any difference in alignment or byte order on the server computer to that of the client computer.
      - The mi_put_string() function
        The mi_put_string() function copies an mi_string (CHAR(x)) value to a buffer.
      - The mi_query_finish() function
        The mi_query_finish() function finishes execution of the current statement.
      - The mi_query_interrupt() function
        The mi_query_interrupt() function interrupts the current statement.
      - The mi_realloc() function
        The mi_realloc() function reallocates a block of user memory to a specified size and returns a pointer to that block.
      - The mi_register_callback() function
        The mi_register_callback() function registers a callback function for a single event type or for all event types.
      - The mi_result_command_name() function
        The mi_result_command_name() function returns the name of the SQL statement that is the current statement.
      - The mi_result_reference() function
        The mi_result_reference() function returns the reference of the last object inserted on the connection.
      - The mi_result_row_count() function
        The mi_result_row_count() function returns the number of rows affected by the current statement.
      - The mi_retrieve_callback() function
        The mi_retrieve_callback() function retrieves the handle of a registered callback.
      - The mi_routine_end() function
        The mi_routine_end() function releases resources associated with a function descriptor.
      - The mi_routine_exec() function
        The mi_routine_exec() function executes the registered user-defined routine or cast function associated with a specified function descriptor.
      - The mi_routine_get() function
        The mi_routine_get() function looks up a registered user-defined routine by a routine signature that is a character string and creates its function descriptor.
      - The mi_routine_get_by_typeid() function
        The mi_routine_get_by_typeid() function looks up a registered user-defined routine (UDR) on the local database server by a routine signature that the function builds from a list of arguments. This function also creates a function descriptor for the UDR.
      - The mi_routine_id_get() function
        The mi_routine_id_get() accessor function returns the routine identifier for the user-defined routine that the specified function descriptor describes.
      - The mi_row_create() function
        The mi_row_create() function creates a row, based on a row descriptor and column data.
      - The mi_row_desc_create() function
        The mi_row_desc_create() function creates a row descriptor from a specified type identifier.
      - The mi_row_desc_free() function
        The mi_row_desc_free() routine frees a row descriptor.
      - The mi_row_free() function
        The mi_row_free() function frees a row structure.
      - The mi_save_set_count() function
        The mi_save_set_count() function returns the number of rows in a save set.
      - The mi_save_set_create() function
        The mi_save_set_create() function creates a save set on the current connection.
      - The mi_save_set_delete() function
        The mi_save_set_delete() function removes a row from a save set.
      - The mi_save_set_destroy() function
        The mi_save_set_destroy() function destroys a save set and frees its resources.
      - The mi_save_set_get_first() function
        The mi_save_set_get_first() function retrieves the first row from a save set.
      - The mi_save_set_get_last() function
        The mi_save_set_get_last() function retrieves the last row from a save set.
      - The mi_save_set_get_next() function
        The mi_save_set_get_next() function traverses a save set in the forward direction.
      - The mi_save_set_get_previous() function
        The mi_save_set_get_previous() function traverses a save set in the backward direction.
      - The mi_save_set_insert() function
        The mi_save_set_insert() function appends a copy of a row to the end of a save set.
      - The mi_save_set_member() function
        The mi_save_set_member() function determines whether a row is a member of any open save set.
      - The mi_server_connect() function
        The mi_server_connect() function establishes a connection between a client LIBMI application and a database server.
      - The mi_server_library_version() function
        The mi_server_library_version() function returns the name of the database server with its major and minor version numbers.
      - The mi_server_reconnect() function
        The mi_server_reconnect() function re-establishes a dropped connection.
      - The mi_set_connection_user_data() function
        The mi_set_connection_user_data() function associates the address of user data with an open connection.
      - The mi_set_default_connection_info() function
        The mi_set_default_connection_info() function sets the default connection parameters with values from a connection-information descriptor that the user provides.
      - The mi_set_default_database_info() function
        The mi_set_default_database_info() function sets the default database parameters with values from a database-information descriptor that the user provides.
      - The mi_set_large() function
        The mi_set_large() macro sets the threshold-tracking field of a multirepresentational opaque type to indicate that the multirepresentational data is stored in a smart large object.
      - The mi_set_parameter_info() function
        The mi_set_parameter_info() function sets the session parameters with values from a parameter-information descriptor that the user provides.
      - The mi_set_vardata() function
        The mi_set_vardata() accessor routine stores data in the data portion of the data in a varying-length structure (such as mi_lvarchar).
      - The mi_set_vardata_align() function
        The mi_set_vardata_align() accessor routine stores data in the data portion of a varying-length structure (such as mi_lvarchar) and adjusts for any initial padding required to align the data.
      - The mi_set_varlen() function
        The mi_set_varlen() accessor routine sets the length of the data in a varying-length structure (such as mi_lvarchar).
      - The mi_set_varptr() function
        The mi_set_varptr() function sets the data pointer in a varying-length structure (such as mi_lvarchar).
      - The mi_stack_limit() function
        The mi_stack_limit() function checks if the specified amount of space is available on the user stack.
      - The mi_statement_command_name() function
        The mi_statement_command_name() function returns the name of an SQL prepared statement.
      - The mi_stream_clear_eof() function
        The mi_stream_clear_eof() function clears the end-of-file marker for a stream.
      - The mi_stream_close() function
        The mi_stream_close() function closes a stream.
      - The mi_stream_eof() function
        The mi_stream_eof() function determines whether the current stream seek position is at the end of the stream.
      - The mi_stream_get_error() function
        The mi_stream_get_error() function returns the last error status for an open stream and clears the error condition.
      - The mi_stream_getpos() function
        The mi_stream_getpos() function returns the current seek position of an open stream.
      - The mi_stream_init() function
        The mi_stream_init() function initializes a user-defined stream.
      - The mi_stream_length() function
        The mi_stream_length() function obtains the length of an open stream.
      - The mi_stream_open_fio() function
        The mi_stream_open_fio() function opens a new stream on an operating-system file.
      - The mi_stream_open_mi_lvarchar() function
        The mi_stream_open_mi_lvarchar() function opens a new stream on varying-length data.
      - The mi_stream_open_str() function
        The mi_stream_open_str() function opens a new stream on a character string.
      - The mi_stream_read() function
        The mi_stream_read() function reads a specified number of bytes from a stream into a buffer.
      - The mi_stream_seek() function
        The mi_stream_seek() function sets the stream seek position for the next read or write operation on an open stream.
      - The mi_stream_set_eof() function
        The mi_stream_set_eof() function sets the end-of-file marker for a stream.
      - The mi_stream_set_error() function
        The mi_stream_set_error() function sets the last error status for an open stream.
      - The mi_stream_setpos() function
        The mi_stream_setpos() function sets the stream seek position for the next read or write operation on an open stream.
      - The mi_stream_tell() function
        The mi_stream_tell() function returns the current seek position of an open stream, relative to the beginning of the stream.
      - The mi_stream_write() function
        The mi_stream_write() function writes a specified number of bytes to an open stream.
      - The mi_streamread_boolean() function
        The mi_streamread_boolean() function reads an mi_boolean (BOOLEAN) value from a stream, converting any difference in the stream representation to that of the internal representation.
      - The mi_streamread_collection() function
        The mi_streamread_collection() function reads a collection structure (LIST, SET, MULTISET) from a stream, converting any difference in the stream representation to that of the internal representation.
      - The mi_streamread_date() function
        The mi_streamread_date() function reads an mi_date (DATE) value from a stream, converting any difference in the stream representation to that of the internal representation.
      - The mi_streamread_datetime() function
        The mi_streamread_datetime() function reads an mi_datetime (DATETIME) value from a stream, converting any difference in the stream representation to that of the internal representation.
      - The mi_streamread_decimal() function
        The mi_streamread_decimal() function reads an mi_decimal (DECIMAL) value from a stream, converting any difference in the stream representation to that of the internal representation.
      - The mi_streamread_double() function
        The mi_streamread_double() function reads an mi_double_precision (FLOAT) value from a stream, converting any difference in the stream representation to that of the internal representation.
      - The mi_streamread_int8() function
        The mi_streamread_int8() function reads an mi_int8 (INT8) value from a stream, converting any difference in the stream representation to that of the internal representation.
      - The mi_streamread_integer() function
        The mi_streamread_integer() function reads an mi_integer (INTEGER) value from a stream, converting any difference in the stream representation to that of the internal representation.
      - The mi_streamread_interval() function
        The mi_streamread_interval() function reads an mi_interval (INTERVAL) value from a stream, converting any difference in the stream representation to that of the internal representation.
      - The mi_streamread_lo() function
        The mi_streamread_lo() function reads smart-large-object data from a stream and copies the data to a smart large object in the default sbspace.
      - The mi_streamread_lo_by_lofd() function
        The mi_streamread_lo_by_lofd() function reads smart-large-object data from a stream and copies the data to the open smart large object that a specified LO file descriptor identifies.
      - The mi_streamread_lvarchar() function
        The mi_streamread_lvarchar() function reads a varying-length structure (mi_lvarchar) value from a stream, converting any difference in the stream representation to that of the internal representation.
      - The mi_streamread_money() function
        The mi_streamread_money() function reads an mi_money (MONEY) value from a stream, converting any difference in the stream representation to that of the internal representation.
      - The mi_streamread_real() function
        The mi_streamread_real() function reads an mi_real (SMALLFLOAT) value from a stream, converting any difference in the stream representation to that of the internal representation.
      - The mi_streamread_row() function
        The mi_streamread_row() function reads a row structure (row type) value from a stream, converting any difference in the stream representation to that of the internal representation.
      - The mi_streamread_smallint() function
        The mi_streamread_smallint() function reads an mi_smallint (SMALLINT) value from a stream, converting any difference in the stream representation to that of the internal representation.
      - The mi_streamread_string() function
        The mi_streamread_string() function reads an mi_string (CHAR(x)) value from a stream.
      - The mi_streamwrite_boolean() function
        The mi_streamwrite_boolean() function writes an mi_boolean (BOOLEAN) value to a stream, converting any difference in the internal representation to that of the stream representation.
      - The mi_streamwrite_collection() function
        The mi_streamwrite_collection() function writes a collection structure (LIST, SET, MULTISET) value to a stream, converting any difference in the internal representation to that of the stream representation.
      - The mi_streamwrite_date() function
        The mi_streamwrite_date() function writes an mi_date (DATE) value to a stream, converting any difference in the internal representation to that of the stream representation.
      - The mi_streamwrite_datetime() function
        The mi_streamwrite_datetime() function writes an mi_datetime (DATETIME) value to a stream, converting any difference in the internal representation to that of the stream representation.
      - The mi_streamwrite_decimal() function
        The mi_streamwrite_decimal() function writes an mi_decimal (DECIMAL) value to a stream, converting any difference in the internal representation to that of the stream representation.
      - The mi_streamwrite_double() function
        The mi_streamwrite_double() function writes an mi_double_precision (FLOAT) value to a stream, converting any difference in the internal representation to that of the stream representation.
      - The mi_streamwrite_int8() function
        The mi_streamwrite_int8() function writes an mi_int8 (INT8) value to a stream, converting any difference in the internal representation to that of the stream representation.
      - The mi_streamwrite_integer() function
        The mi_streamwrite_integer() function writes an mi_integer (INTEGER) value to a stream, converting any difference in the internal representation to that of the stream representation.
      - The mi_streamwrite_interval() function
        The mi_streamwrite_interval() function writes an mi_interval (INTERVAL) value to a stream, converting any difference in the internal representation to that of the stream representation.
      - The mi_streamwrite_lo() function
        The mi_streamwrite_lo() function writes a smart large object to a stream, converting any difference in the internal representation to that of the stream representation.
      - The mi_streamwrite_lvarchar() function
        The mi_streamwrite_lvarchar() function writes a varying-length structure (mi_lvarchar) value to a stream, converting any difference in the internal representation to that of the stream representation.
      - The mi_streamwrite_money() function
        The mi_streamwrite_money() function writes an mi_money (MONEY) value to a stream, converting any difference in the internal representation to that of the stream representation.
      - The mi_streamwrite_real() function
        The mi_streamwrite_real() function writes an mi_real (SMALLFLOAT) value to a stream, converting any difference in the internal representation to that of the stream representation.
      - The mi_streamwrite_row() function
        The mi_streamwrite_row() function writes a row structure (row type) value to a stream, converting any difference in the internal representation to that of the stream representation.
      - The mi_streamwrite_smallint() function
        The mi_streamwrite_smallint() function writes an mi_smallint (SMALLINT) value to a stream, converting any difference in the internal representation to that of the stream representation.
      - The mi_streamwrite_string() function
        The mi_streamwrite_string() function writes an mi_string (CHAR(x)) value to a stream.
      - The mi_string_to_date() function
        The mi_string_to_date() function converts a text (string) representation of a date value to its binary (internal) DATE representation.
      - The mi_string_to_datetime() function
        The mi_string_to_datetime() function converts a text (string) representation of a date, time, or date and time value to its internal (binary) DATETIME representation.
      - The mi_string_to_decimal() function
        The mi_string_to_decimal() function converts a text (string) representation of a decimal value to its binary (internal) DECIMAL representation.
      - The mi_string_to_interval() function
        The mi_string_to_interval() function converts a text (string) representation of an interval value to its binary (internal) INTERVAL representation.
      - The mi_string_to_lvarchar() function
        The mi_string_to_lvarchar() function converts a null-terminated string to a varying-length structure.
      - The mi_string_to_money() function
        The mi_string_to_money() function converts a text (string) representation of a monetary value to its binary (internal) MONEY representation.
      - The mi_switch_mem_duration() function
        The mi_switch_mem_duration() function switches the current memory duration.
      - The mi_sysname() function
        The mi_sysname() function obtains the name of the default database server.
      - The mi_system() function
        The mi_system() function allows you to execute operating system commands from within a DataBlade® module or C UDR.
      - The mi_td_cast_get() function
        The mi_td_cast_get() function looks up a registered cast function by the type descriptors of its source and target data types and creates its function descriptor.
      - The mi_tracefile_set() function
        The mi_tracefile_set() function sets the trace-output file. The database server writes trace messages to this file.
      - The mi_tracelevel_set() function
        The mi_tracelevel_set() function sets the trace level for specified trace classes.
      - The mi_transaction_state() function (Server)
        The mi_transaction_state() function returns the current transaction state (none, implicit, or explicit).
      - The mi_transition_type() function
        The mi_transition_type() accessor function obtains the type of state transition from a transition descriptor.
      - The mi_trigger_event() function
        The mi_trigger_event() function returns the trigger event information for the current trigger event.
      - The mi_trigger_get_new_row() function
        The mi_trigger_get_new_row() function returns the name of the new row value if the MI_TRIGGER_FOREACH_EVENT bit is set, which implies that neither the MI_TRIGGER_BEFORE_EVENT nor the MI_TRIGGER_AFTER_EVENT bits are set.
      - The mi_trigger_get_old_row() function
        The mi_trigger_get_old_row() function returns the name of the old row value if the MI_TRIGGER_FOREACH_EVENT bit is set, which implies that the MI_TRIGGER_BEFORE_EVENT or the MI_TRIGGER_AFTER_EVENT bits are not set. In addition, mi_trigger_get_old_row() returns all the columns in the requested row, not just those columns into which data was explicitly inserted. Columns with default data are also returned.
      - The mi_trigger_level() function
        The mi_trigger_level() function returns the nesting level value of the current trigger.
      - The mi_trigger_name() function
        The mi_trigger_name() function returns the name of the currently executing trigger.
      - The mi_trigger_tabname() function
        The mi_trigger_tabname() function returns the triggering table or view name on which the current trigger action statement was started.
      - The mi_try_lock_memory() function
        The mi_try_lock_memory() function requests a lock on a named-memory block specified by name and memory duration.
      - The mi_type_align() function
        The mi_type_align() function obtains the alignment for a data type from its type descriptor.
      - The mi_type_byvalue() function
        The mi_type_byvalue() function checks a type descriptor to determine whether a data type is passed by value or by reference.
      - The mi_type_constructor_typedesc() function
        The mi_type_constructor_typedesc() function obtains a type descriptor for a constructed data type.
      - The mi_type_element_typedesc() function
        The mi_type_element_typedesc() function obtains the type descriptor for the elements of a collection data type from its type descriptor.
      - The mi_type_full_name() function
        The mi_type_full_name() function obtains the full name (owner.typename) of a data type from its type descriptor.
      - The mi_type_length() function
        The mi_type_length() function obtains the length of a data type from its type descriptor.
      - The mi_type_maxlength() function
        The mi_type_maxlength() function obtains the maximum length of a data type from its type descriptor.
      - The mi_type_owner() function
        The mi_type_owner() function obtains the owner of a data type from its type descriptor.
      - The mi_type_precision() function
        The mi_type_precision() function obtains the precision of a data type from its type descriptor.
      - The mi_type_qualifier() function
        The mi_type_qualifier() function obtains the qualifier of a data type from its type descriptor.
      - The mi_type_scale() function
        The mi_type_scale() function obtains the scale of the data type from its type descriptor.
      - The mi_type_typedesc() function
        The mi_type_typedesc() function creates a type descriptor, given a type identifier.
      - The mi_type_typename() function
        The mi_type_typename() function obtains the name of a data type from its type descriptor.
      - The mi_typedesc_typeid() function
        The mi_typedesc_typeid() function obtains the type identifier of a data type from its type descriptor.
      - The mi_typeid_equals() function
        The mi_typeid_equals() function determines whether two type identifiers represent the same data type.
      - The mi_typeid_is_builtin() function
        The mi_typeid_is_builtin() function determines whether a type identifier is for a built-in data type.
      - The mi_typeid_is_collection() function
        The mi_typeid_is_collection() function determines whether a type identifier is for a collection.
      - The mi_typeid_is_complex() function
        The mi_typeid_is_complex() function determines whether a type identifier is for a complex data type.
      - The mi_typeid_is_distinct() function
        The mi_typeid_is_distinct() function determines whether a type identifier is for a distinct data type.
      - The mi_typeid_is_list() function
        The mi_typeid_is_list() function determines whether a type identifier is for a LIST collection data type.
      - The mi_typeid_is_multiset() function
        The mi_typeid_is_multiset() function determines whether a type identifier is for a MULTISET collection data type.
      - The mi_typeid_is_row() function
        The mi_typeid_is_row() function determines whether a type identifier is for an SQL row data type.
      - The mi_typeid_is_set() function
        The mi_typeid_is_set() function determines whether a type identifier is for a SET collection data type.
      - The mi_typename_to_id() function
        The mi_typename_to_id() function creates a type identifier for a data type, given the type name in LVARCHAR format.
      - The mi_typename_to_typedesc() function
        The mi_typename_to_typedesc() function creates a type descriptor for a data type, given the type name in LVARCHAR format.
      - The mi_typestring_to_id() function
        The mi_typestring_to_id() function creates a type identifier for a data type, given the type name as a null-terminated string.
      - The mi_typestring_to_typedesc() function
        The mi_typestring_to_typedesc() function creates a type descriptor for a data type, given the type name as a null-terminated string.
      - The mi_udr_lock() function
        The mi_udr_lock() function locks an instance of a UDR onto the virtual processor (VP) on which it begins execution.
      - The mi_unlock_memory() function
        The mi_unlock_memory() function unlocks a named-memory block specified by name and memory duration.
      - The mi_unregister_callback() function
        The mi_unregister_callback() function unregisters a callback for an event type or for all event types.
      - The mi_value() function
        The mi_value() function retrieves a column value from a row, given the column identifier.
      - The mi_value_by_name() function
        The mi_value_by_name() function retrieves a column value from a row, given the column name.
      - The mi_var_copy() function
        The mi_var_copy() function creates a copy of a varying-length structure.
      - The mi_var_free() function
        The mi_var_free() function frees the specified varying-length structure.
      - The mi_var_to_buffer() function
        The mi_var_to_buffer() function copies data from a varying-length structure to a buffer.
      - The mi_version_comparison() function
        The mi_version_comparison() function compares the version of two instances of HCL Informix®.
      - The mi_vpinfo_classid() function
        The mi_vpinfo_classid() function obtains the VP-class identifier for the VP class in which the current UDR is running.
      - The mi_vpinfo_isnoyield() function
        The mi_vpinfo_isnoyield() function determines whether the virtual processor (VP) on which the current UDR is executing is part of a nonyielding user-defined VP class.
      - The mi_vpinfo_vpid() function
        The mi_vpinfo_vpid() function obtains the VP identifier of the virtual processor (VP) on which the user-defined routine (UDR) is executing.
      - The mi_xa_get_current_xid() function
        The mi_xa_get_current_xid() function returns the pointer to the current XID structure for an XA-compliant, external data source. The XID structure is defined in the $INFORMIXDIR/incl/public/xa.h file.
      - The mi_xa_get_xadatasource_rmid() function
        The mi_xa_get_xadatasource_rmid() function gets the resource manager ID that was previously created in the database for an XA-compliant, external data source.
      - The mi_xa_register_xadatasource() function
        The mi_xa_register_xadatasource() function registers an XA data source with the current transaction. The registration is dynamic and is applicable for the current transaction only. The DataBlade® must register participating data sources into each transaction.
      - The mi_xa_unregister_xadatasource() function
        The mi_xa_unregister_xadatasource() function unregisters the previously registered XA data source from the transaction.
      - The mi_yield() function
        The mi_yield() routine yields processing to other database server threads.
      - The mi_zalloc() function
        The mi_zalloc() function allocates and zero-fills a block of memory of the given size and returns a pointer to a block of user memory of the specified size.
      - The rdatestr() function
        The rdatestr() function converts an internal DATE value to a character string.
      - The rdayofweek() function
        The rdayofweek() function returns the day of the week as an integer value for an internal DATE.
      - The rdefmtdate() function
        The rdefmtdate() function uses a formatting mask to convert a character string to an internal DATE format.
      - The rdownshift() function
        The rdownshift() function changes all the uppercase characters within a null-terminated string to lowercase characters.
      - The rfmtdate() function
        The rfmtdate() function uses a formatting mask to convert an internal DATE value to a character string.
      - The rfmtdec() function
        The rfmtdec() function uses a formatting mask to convert a decimal value to a character string.
      - The rfmtdouble() function
        The rfmtdouble() function uses a formatting mask to convert a C double value to a character string.
      - The rfmtlong() function
        The rfmtlong() function uses a formatting mask to convert a C long value to a character string.
      - The rjulmdy() function
        The rjulmdy() function creates an array of three short integer values that represent the month, day, and year from an internal DATE value.
      - The rleapyear() function
        The rleapyear() function returns 1 (TRUE) when the argument that is passed to it is a leap year and 0 (FALSE) when it is not.
      - The rmdyjul() function
        The rmdyjul() function creates an internal DATE from an array of three short integer values that represent month, day, and year.
      - The rstod() function
        The rstod() function converts a null-terminated string into a C double value.
      - The rstoi() function
        The rstoi() function converts a null-terminated string into a short integer value.
      - The rstol() function
        The rstol() function converts a null-terminated string into a long integer value.
      - The rstrdate() function
        The rstrdate() function converts a character string to an internal DATE.
      - The rtoday() function
        The rtoday() function returns the system date as a long integer value.
      - The rupshift() function
        The rupshift() function changes all the characters within a null-terminated string to uppercase characters.
      - The stcat() function
        The stcat() function concatenates one null-terminated string to the end of another.
      - The stchar() function
        The stchar() function stores a null-terminated string in a fixed-length string, padding the end with blanks, if necessary.
      - The stcmpr() function
        The stcmpr() function compares two null-terminated strings.
      - The stcopy() function
        The stcopy() function copies a null-terminated string from one location in memory to another location.
      - The stleng() function
        The stleng() function returns the length, in bytes, of a null-terminated string that you specify.
  - DataBlade® Developers Kit
    The DataBlade® Developers Kit (DBDK) guides contain information about the tools you can use to develop and package DataBlade modules, which extend the functionality of HCL Informix® databases.
  - J/Foundation Developer's Guide
    The J/Foundation Developer's Guide describes how to write user-defined routines (UDRs) in the Java™ programming language for Informix®.
  - R-Tree Index User's Guide
    The Informix® R-Tree Index User's Guide describes the HCL Informix R-tree secondary access method and how to access and use its components.
  - User-Defined Routines and Data Types Developer's Guide
    The Informix® User-Defined Routines and Data Types Developer's Guide describes how to define new data types and enable user-defined routines (UDRs) to extend HCL Informix.
  - Virtual-Table Interface Guide
    The Informix® Virtual-Table Interface Programmer's Guide explains how to create a primary access method with the Virtual-Table Interface (VTI) so that users have a single SQL interface to HCL Informix tables and to data that does not conform to the storage scheme of HCL Informix.
  - Virtual-Index Interface Guide
    The Informix® Virtual-Index Interface Programmer's Guide explains how to create a secondary access method with the Virtual-Index Interface (VII) to extend the built-in indexing schemes of HCL Informix typically with a DataBlade® module.

The mi_system() function

The mi_system() function allows you to execute operating system commands from within a DataBlade® module or C UDR.

Syntax

mi_integer mi_system(const mi_char *cmd);

cmd: An operating system command, surrounded by quotation marks.


Valid in client LIBMI application?	Valid in user-defined routine?
Yes	Yes

Usage

Use the mi_system() function from within a DataBlade® module or C UDR to execute operating system commands, external user executables, or shell scripts. The mi_system() function creates a child process to execute the command, waits for its completion, and then returns the command's exit status to the calling routine. The child process inherits the user and group IDs of the client running the session.

The mi_system() function does not perform any validation on the command you run, therefore, you must take care to run appropriate and accurate commands. For information about good coding practices within user-defined routines, see the Informix® DataBlade® API Programmer's Guide.

The following code snippet shows how to use the mi_system() function to execute the rm /tmp/lo* command:

ret = mi_system(rm /tmp/lo*); 
check_retval(ret); /* Check exit status */

To use the mi_system() function on Windows™ computers, specify the name and absolute path name of the user executable or file to use within the mi_system() call. For example:

 mi_system("/p1/p2/myexe param1 param2")

mi_system("sh /p1/p2/myscript.sh")

The mi_system() function treats the first string within the quotation marks as the command and the following strings as parameters passed to the command.

To run a command that includes symbols interpreted by the shell, put them inside a shell script and run the shell script through mi_system(). For example, this command does not work:

mi_system("echo 'Check this out' >> /tmp/myfile")

because mi_system() treats echo as the command to be run and 'Check this out', >>, and /tmp/myfile as its parameters. To successfully run these commands, create a shell script, such as mysh.sh, which contains the following lines:

#!/bin/sh
echo 'Check this out' >> /tmp/myfile

Next, run the following command:

mi_system("sh /p1/p2/mysh.sh")

For more information about executing operating system commands, see the Informix® DataBlade® API Programmer's Guide.

Return values

An integer: The success, failure, or error code returned by the operating system command.
MI_ERROR: The operating system command cannot be executed.