Index

• -, (hyphen), as formatting character
• * (asterisk symbol), as formatting character
• , (comma symbol) (1), (2), (3), (4), (5)
• $ (dollar sign) (1), (2)
• . (period symbol) (1), (2), (3), (4)
• + (plus sign)
• # (pound sign)
• ? (question mark), input-parameter indicator
• ; (semicolon symbol) (1), (2)
• __myErrors__ trace class
• & (ampersand symbol)
• .bld file extension
• .dll file extension
• .dsw file extension
• .mak file extension
• .o file extension
• _open(Windows) system call
• .so file extension
• .trc file extension

• accept() system call
• Accessibility
  • dotted decimal format of syntax diagrams
  • syntax diagrams, reading in a screen reader
• Account name.
  • See also User account.
• Aggregate algorithm
• Aggregate function
  • See also Built-in aggregate function; User-defined aggregate.
  • built-in
  • creating
  • overloaded
  • user-defined
• Aggregate state
  • See also User-defined aggregate.
  • allocating a new
  • deallocating
  • defined (1), (2)
  • determining
  • nonsimple (1), (2)
  • opaque-type
  • simple (1), (2), (3)
  • single-valued
• Aggregate support function
  • defined (1), (2)
  • determining required
  • summary of
  • writing
• AIO VP.
  • See also Asynchronous I/O virtual-processor (AIO VP) class.
• alarm() system call
• Alignment.
  • See also Type alignment.
• ALIGNMENT opaque-type modifier
• All-events callback (1), (2)
• Allocation extent size
• ALTER FUNCTION statement
• ALTER PROCEDURE statement
• ALTER ROUTINE statement
• ALTER TABLE statement (1), (2)
• Ampersand symbol (&)
• ANSI SQL standards
  • ANSI-compliant database
  • date and/or time-string format
  • interval-string format
  • runtime-error values
  • SQLSTATE class values
  • warning values
• Arithmetic operations
  • See also Nonarithmetic operations.
  • date and/or time values
  • decimal values
  • fixed-point values
  • INT8 values
• assign() support function
  • defined (1), (2)
  • incrementing the reference count (1), (2)
• Asterisk symbol (*), as formatting character
• Asynchronous I/O virtual-processor (AIO VP) class (1), (2), (3), (4)
• Availability
• ax_reg() function
• ax_unreg( ) function

• BEGIN WORK statement (1), (2), (3), (4)
• Binary operator (1), (2)
• Binary representation
  • Boolean data (1), (2)
  • character data (1), (2), (3)
  • collection (1), (2), (3)
  • column values in (1), (2), (3), (4), (5)
  • date and/or time data (1), (2), (3), (4)
  • date data (1), (2), (3)
  • decimal data (1), (2), (3), (4)
  • defined
  • distinct data type
  • fixed-length opaque type
  • fixed-point data
  • floating-point data (1), (2)
  • input parameters
  • INT8 (mi_int8) (1), (2), (3), (4)
  • INTEGER (mi_integer) (1), (2)
  • integer data (1), (2)
  • interval data (1), (2), (3)
  • LO handle (1), (2), (3), (4)
  • mi_exec() results
  • mi_exec_prepared_statement() results
  • mi_open_prepared_statement() results
  • monetary data (1), (2), (3), (4)
  • opaque type (1), (2), (3), (4), (5), (6), (7), (8)
  • row type (1), (2)
  • SMALLINT (mi_smallint) (1), (2)
  • varying-length opaque type
• bind() system call
• BITVARYING data type (1), (2)
  • corresponding DataBlade API data type
• BLOB data type
  • See also Smart-large-object data type.
  • column-level storage characteristics
  • corresponding DataBlade API data type (1), (2)
  • defined (1), (2)
  • deleting (1), (2)
  • format of (1), (2)
  • inserting (1), (2), (3)
  • obtaining column value for
  • reference count of
  • selecting (1), (2), (3)
  • updating (1), (2), (3)
• Blocking I/O call (1), (2), (3)
• Boldface type
• Boolean data
  • binary representation (1), (2)
  • in opaque type
  • support for
  • text representation (1), (2)
• BOOLEAN data type (1), (2)
  • See also mi_boolean data type.
  • corresponding DataBlade API data type
  • format of (1), (2)
  • obtaining column value for
  • returned from a user-defined function
  • valid values
• Boolean function
  • defined (1), (2)
  • selectivity of
  • uses for (1), (2)
• Boolean string
• BOOLEAN value, passing mechanism for
• Buffered I/O (1), (2)
• Built-in aggregate function
• Built-in cast
• Built-in data type (1), (2)
• Bulk copy
• bycmpr() function
• bycopy() function
• byfill() function
• byleng() function
• Byte data
  • byte order
  • copying (1), (2)
  • data conversion of
  • data types for
  • ESQL/C functions for (1), (2)
  • in opaque type (1), (2)
  • manipulating
  • operations on
  • portability of
  • processing
  • receiving from client
  • sending to client
  • transferring between computers
  • type alignment
• BYTE data type (1), (2)
  • See also Simple large object.
• Byte order
  • byte data
  • converting
  • LO handle
  • mi_date values
  • mi_datetime values
  • mi_decimal values (1), (2)
  • mi_double_precision values
  • mi_int8 values
  • mi_integer values
  • mi_interval values
  • mi_money values
  • mi_real values
  • mi_smallint values
  • on client computer
• Byte-range lock.
  • See also Smart-large-object lock, byte-range.

• C compiler (1), (2), (3), (4)
• C data type
  • char (1), (2), (3), (4), (5)
  • character conversion
  • DECIMAL conversions
  • double (1), (2), (3), (4)
  • float (1), (2)
  • INT8 conversions
  • signed eight-byte integer (1), (2)
  • signed four-byte integer (1), (2), (3)
  • signed one-byte integer (1), (2)
  • signed two-byte integer (1), (2), (3)
  • unsigned eight-byte integer (1), (2)
  • unsigned four-byte integer (1), (2)
  • unsigned one-byte integer (1), (2)
  • unsigned two-byte integer (1), (2)
  • void * (1), (2), (3), (4), (5), (6), (7), (8), (9)
• C function.
  • See also User-defined routine (UDR).
• C UDR.
  • See also User-defined routine (UDR).
• Callback function
  • all-events (1), (2)
  • arguments
  • client LIBMI (1), (2)
  • clntexcpt_callback()
  • continuing exception handling after
  • creating
  • defined (1), (2), (3)
  • deleting
  • disabling (1), (2)
  • enabling (1), (2)
  • end-of-session
  • end-of-statement
  • end-of-transaction
  • endxact_callback()
  • exception (1), (2), (3), (4)
  • excpt_callback()
  • excpt_callback2()
  • excpt_callback3()
  • handle
  • initializing
  • invoking
  • memory management in
  • MI_PROC_CALLBACK modifier
  • obtaining event information in
  • parameters
  • pointer to
  • providing all exception handling
  • providing arguments to
  • registering (1), (2), (3), (4)
  • restrictions on content
  • retrieving
  • return value
  • returning information
  • sample (1), (2), (3)
  • sample declaration
  • state-change (1), (2)
  • state-transition (1), (2)
  • system-default (1), (2)
  • types of
  • unregistering (1), (2)
  • user data in (1), (2), (3)
  • where registration is stored
  • writing
• Callback-function pointer (1), (2)
• Callback handle (1), (2)
• calloc() system call (1), (2)
• Cast
  • built-in
  • explicit (1), (2), (3), (4), (5), (6)
  • implicit (1), (2), (3), (4), (5)
  • opaque-type support function as
  • registering
  • system
  • system-defined (1), (2)
  • types of
  • ways to call
• Cast function
  • creating
  • defined
  • executing with Fastpath
  • looking up with Fastpath
  • opaque-type support functions as
• Cast functiondefined
• char (C) data type
  • See also Character data; mi_char data type; mi_char1 data type; mi_string data type.
  • corresponding DataBlade API data type (1), (2), (3), (4), (5)
  • mi_date conversion
  • mi_datetime conversion
  • mi_decimal conversion (1), (2), (3)
  • mi_int8 conversion (1), (2)
  • mi_interval conversion
• CHAR data type
  • See also Character data
  • as return value
  • as routine argument
  • corresponding DataBlade API data type (1), (2), (3), (4), (5), (6)
  • DataBlade API functions for (1), (2)
  • ESQL/C functions for (1), (2)
  • functions for
  • obtaining column value for
  • operations
  • precision of
• CHAR value, passing mechanism for
• Character data
  • See also char (C) data type; mi_char data type; mi_char1 data type; mi_lvarchar data type; mi_string data type.
  • binary representation (1), (2), (3)
  • converting from varying-length structure
  • converting to varying-length structure
  • copying (1), (2)
  • data conversion of (1), (2)
  • data types for
  • date/time value.
    • See also Date/time string.
  • date value.
    • See also Date string.
  • decimal value.
    • See also Decimal string.
  • in opaque type (1), (2), (3), (4)
  • interval value.
    • See also Interval string.
  • length of (1), (2)
  • monetary value.
    • See also Monetary string.
  • multibyte (1), (2), (3)
  • obtaining type information
  • operations
  • portability of
  • processing (1), (2), (3)
  • receiving from client
  • routine argument as
  • routine return-value as
  • sending to client
  • text representation (1), (2)
  • transferring
  • type alignment (1), (2)
  • varying-length
• circle sample opaque type
  • export function
  • exportbin function
  • external representation
  • import function
  • importbin function
  • input function
  • internal representation
  • output function
  • receive function
  • registering
  • send function
  • support functions
• CLASS routine modifier (1), (2), (3), (4), (5)
• Client application
  • See also Client LIBMI application.
  • as calling module (1), (2)
  • converting date and/or time data
  • converting date data
  • converting fixed-point data
  • converting LO handles
  • converting mi_lvarchar values
  • end-user formats (1), (2), (3), (4), (5), (6)
  • session thread
  • transferring byte data
  • transferring character data
  • transferring date data
  • transferring date/time data
  • transferring fixed-point data
  • transferring floating-point data
  • transferring integer data (1), (2), (3)
  • transferring LO handle
• Client connection (1), (2), (3), (4), (5)
  • See also Connection.
• Client LIBMI application
  • See also Client application; DataBlade API module.
  • aborting statement in
  • callback return value
  • client LIBMI errors
  • column values in
  • connection descriptor in registration
  • defined
  • event handling in (1), (2)
  • exception handling in (1), (2)
  • file management
  • handling events
    • See also Event handling; Exception handling.
  • heap space (1), (2)
  • mi_dalloc() and
  • passing mechanism
  • session management in (1), (2)
  • state-transition event (1), (2), (3)
  • transaction management in (1), (2), (3)
  • user-memory management
  • using Fastpath
• Client LIBMI callback (1), (2)
• Client LIBMI error, defined
• Client LIBMI event, error levels
• Client locale (1), (2), (3)
• CLIENT_LOCALE environment variable (1), (2)
• Client session.
  • See also Session.
• CLOB data type
  • See also Smart large-object data type.
  • column-level storage characteristics
  • corresponding DataBlade API data type (1), (2)
  • defined (1), (2)
  • deleting (1), (2)
  • format of (1), (2)
  • inserting (1), (2), (3)
  • obtaining column value for
  • reference count of
  • selecting (1), (2), (3)
  • updating (1), (2), (3)
• close() system call (1), (2)
• CLOSE DATABASE statement
• Code, sample, conventions for
• Code-set conversion
  • functions for
  • opaque data types
• Collection
  • accessing elements of
  • binary representation (1), (2), (3)
  • cardinality of
  • checking type identifier for
  • closing
  • collection subquery (1), (2)
  • creating
  • data structures for
  • defined
  • deleting element from
  • element
  • element type of
  • fetching element from
  • inserting element into
  • kinds of
  • MI_DATUM element (1), (2), (3), (4)
  • obtaining column value for
  • open mode
  • opening
  • parallelizable UDR and
  • releasing resources
  • text representation (1), (2), (3)
  • updating
• Collection cursor
  • See also Collection descriptor; Cursor.
  • characteristics of
  • closing
  • cursor position (1), (2)
  • default
  • defined
  • deleting element from
  • freeing
  • inserting element into
  • open mode
  • opening
  • retrieving element from
  • scope of
  • updating element in
  • where stored
• Collection descriptor
  • constructor for (1), (2), (3)
  • defined (1), (2)
  • destructor for (1), (2), (3), (4)
  • freeing
  • memory duration of (1), (2)
• Collection string
• Collection structure
  • constructor for (1), (2), (3)
  • corresponding SQL data type
  • defined (1), (2)
  • destructor for (1), (2)
  • format of
  • freeing (1), (2)
  • in opaque type
  • memory duration of (1), (2)
  • scope of
• Collection subquery (1), (2)
• Column
  • accessor functions (1), (2)
  • constraint.
    • See also Constraints.
  • data distribution of
  • distribution information (1), (2)
  • functions for (1), (2)
  • handling NULL value
  • identifier for.
    • See also Column identifier; Column number.
  • name of (1), (2), (3)
  • NOT NULL constraint (1), (2), (3), (4)
  • NULL value in
  • number of
  • obtaining information about
  • precision of (1), (2), (3), (4), (5), (6), (7), (8), (9), (10), (11)
  • scale of (1), (2), (3), (4), (5), (6), (7)
  • type descriptor for
  • type descriptor of (1), (2)
  • type identifier of (1), (2)
  • value of.
    • See also Column value.
• Column identifier
  • column number and
  • defined
  • for column information
  • for column value
  • obtaining
• Column number (1), (2), (3), (4)
• Column type descriptor
• Column value
  • binary representation of (1), (2), (3), (4), (5)
  • collection
  • MI_DATUM data type (1), (2), (3), (4), (5), (6), (7)
  • normal
  • obtaining (1), (2)
  • providing
  • row type
  • SQL NULL value
  • text representation of (1), (2), (3), (4), (5)
  • value buffer for
• COMBINE aggregate support function (1), (2), (3), (4)
• Comma symbol (,) (1), (2), (3), (4), (5)
• Command.
  • See also SQL command.
• Command-line conventions
  • how to read
  • sample diagram
• COMMIT WORK statement (1), (2), (3), (4)
• Commutator function (1), (2)
• COMMUTATOR routine modifier (1), (2)
• Companion UDR
  • argument data type
  • argument length
  • argument type (1), (2)
  • column-argument information
  • column number
  • constant-argument information
  • constant argument value (1), (2)
  • data-distribution information
  • determining if argument is NULL (1), (2)
  • information about
  • routine identifier (1), (2)
  • routine name (1), (2)
  • table identifier
• Complex data type (1), (2)
• Compliance
  • with industry standards
• Concurrency (1), (2)
• Configuration parameter
  • as part of server environment
  • MSGPATH
  • obtaining value of
  • SINGLE_CPU_VP
  • STACKSIZE
  • SYSSBSPACENAME
  • VPCLASS
• Connection
  • See also Session management.
  • account password
  • client (1), (2), (3)
  • closing
  • connection parameters for
  • current
  • database name (1), (2), (3), (4), (5)
  • database parameters for
  • database server name (1), (2), (3)
  • default
  • defined
  • descriptor for.
    • See also Connection descriptor.
  • establishing (1), (2), (3)
  • initializing (1), (2)
  • obtaining connection information
  • parent
  • raising exceptions on
  • server port (1), (2), (3)
  • session context (1), (2), (3), (4), (5), (6)
  • UDR (1), (2), (3)
  • user-account name (1), (2), (3), (4)
  • user-account password (1), (2), (3)
  • user data associated with (1), (2), (3)
• Connection descriptor
  • See also Session-duration connection descriptor.
  • caching (1), (2), (3)
  • constructor for (1), (2), (3), (4)
  • defined (1), (2), (3)
  • destructor for (1), (2), (3), (4)
  • for a client LIBMI application
  • for a UDR
  • freeing
  • information in
  • invalid
  • memory duration of (1), (2), (3), (4), (5)
  • NULL-valued (1), (2), (3), (4), (5)
  • obtaining (1), (2)
  • raising an exception
  • registering a callback
  • user data in (1), (2), (3)
• Connection-information descriptor
  • defined
  • fields of
  • mi_server_connect() usage
  • populating (1), (2)
  • purpose
  • setting
• Connection parameter
  • current
  • default
  • obtaining (1), (2), (3)
  • setting
  • system-default
  • user-defined
  • using
• Constant
  • access-method
  • access-mode
  • argument-type
  • buffering-mode
  • cursor-action
  • date, time, or date and time qualifier (1), (2)
  • file-mode
  • for smart large objects (1), (2)
  • iterator-status (1), (2)
  • lock-mode
  • NULL
  • open-mode
  • statement-status
• Constraint
  • checking
  • NOT NULL (1), (2), (3), (4)
  • restrictions in UDR
• Constructor
  • collection descriptor (1), (2), (3)
  • collection structure (1), (2), (3)
  • connection descriptor (1), (2), (3), (4)
  • current memory duration
  • defined
  • error descriptor (1), (2)
  • file descriptor (1), (2), (3)
  • function descriptor (1), (2)
  • LO file descriptor
  • LO handle (1), (2), (3)
  • LO-specification structure (1), (2), (3)
  • LO-status structure (1), (2), (3)
  • memory allocation in
  • MI_FPARAM (1), (2), (3), (4)
  • MI_LO_LIST
  • named memory
  • PER_COMMAND duration
  • PER_ROUTINE duration
  • PER_SESSION duration
  • PER_STMT_EXEC duration
  • PER_STMT_PREP duration
  • PER_SYSTEM duration
  • PER_TRANSACTION duration
  • routine argument
  • routine return value
  • row descriptor (1), (2), (3)
  • row structure (1), (2), (3)
  • save-set structure (1), (2), (3)
  • session-duration connection descriptor (1), (2)
  • session-duration function descriptor (1), (2)
  • statement descriptor (1), (2), (3)
  • stream descriptor (1), (2)
  • user memory (1), (2), (3)
  • varying-length structure (1), (2), (3)
• Contact information
• Control mode
  • binary representation
  • determining
  • for basic SQL statement
  • for prepared statement
  • text representation
  • types of
• Conventions
  • command-line
  • DataBlade API modules
  • documentation
  • function syntax
  • sample-code
  • syntax diagrams
  • syntax notation
  • typographical
• Copy file
• Cost function
  • argument functions for
  • argument information
  • defined (1), (2)
• COSTFUNC routine modifier (1), (2)
• CPU virtual-processor (CPU VP) class
  • See also Virtual-processor (VP) class.
  • adding VPs
  • availability of
  • blocking
  • concurrency of
  • defined (1), (2)
  • dropping VPs
  • monitoring (1), (2)
  • parallelizable UDR and
  • PDQ and
  • thread yielding
  • using (1), (2), (3), (4)
  • yielding
• CPU VP.
  • See also CPU virtual-processor (CPU VP) class.
• CREATE AGGREGATE statement (1), (2)
• CREATE CAST statement (1), (2), (3), (4), (5), (6), (7), (8)
• CREATE DISTINCT TYPE statement
• CREATE FUNCTION statement
  • See also CREATE PROCEDURE statement; Routine modifier.
  • commutator functions (1), (2)
  • EXTERNAL NAME clause (1), (2)
  • handling multiple rows
  • handling NULL values (1), (2)
  • iterator functions (1), (2)
  • LANGUAGE clause
  • negator functions (1), (2)
  • OUT parameter
  • parallelizable functions
  • registering aggregate support functions
  • RETURNS clause
  • routine arguments
  • routine modifiers.
    • See also Routine modifier.
  • routine return value
  • specifying VP class (1), (2)
  • stack size
  • use (1), (2)
  • variant functions (1), (2)
  • WITH clause
  • with Fastpath interface
• CREATE OPAQUE TYPE statement
  • ALIGNMENT modifier
  • INTERNALLENGTH modifier (1), (2)
  • MAXLEN modifier (1), (2)
  • opaque-type modifiers.
    • See also Opaque-type modifier.
  • PASSEDBYVALUE modifier (1), (2)
  • use (1), (2), (3)
• CREATE PROCEDURE statement
  • See also CREATE FUNCTION statement; Routine modifier.
  • EXTERNAL NAME clause (1), (2)
  • handling NULL values (1), (2)
  • LANGUAGE clause
  • routine arguments
  • routine modifiers.
    • See also Routine modifier.
  • routine return value
  • specifying VP class (1), (2)
  • stack size
  • use
  • variant procedures
  • WITH clause
  • with Fastpath interface
• CREATE TABLE statement (1), (2), (3), (4)
• CREATE XADATASOURCE statement
• CREATE XADATASOURCE TYPE statement
• Currency symbol
• Current processing locale (1), (2)
• Current statement
  • control mode of
  • current row
  • cursor for (1), (2), (3)
  • data structures for row (1), (2)
  • DDL statement as (1), (2)
  • defined (1), (2)
  • determining if completed
  • DML statement as (1), (2)
  • error in (1), (2), (3)
  • finishing execution of (1), (2)
  • freeing
  • generating (1), (2)
  • implicit statement descriptor for (1), (2)
  • interrupting (1), (2)
  • name of SQL statement (1), (2), (3), (4)
  • no more results (1), (2)
  • number of rows affected by (1), (2)
  • parallelizable UDR and
  • processing complete
  • query (1), (2)
  • releasing resources for (1), (2)
  • results of
  • row descriptor for (1), (2), (3)
  • row structure for
  • status of (1), (2), (3), (4), (5)
• Cursor
  • characteristics of (1), (2)
  • closing (1), (2), (3), (4), (5), (6)
  • collection.
    • See also Collection cursor.
  • defined
  • explicit.
    • See also Explicit cursor.
  • fetch absolute
  • fetch first
  • fetch last
  • fetch next
  • fetch previous
  • fetch relative
  • fetching rows into
  • freeing
  • hold (1), (2), (3), (4), (5)
  • implicit.
    • See also Implicit cursor.
  • iterator function with
  • lifespan of (1), (2)
  • memory duration for (1), (2)
  • mode of (1), (2)
  • name (1), (2)
  • opening
  • read-only (1), (2), (3), (4), (5), (6), (7), (8)
  • retrieving row from
  • routine invocation and
  • row
  • scope of
  • scroll (1), (2), (3), (4), (5), (6)
  • sequential (1), (2), (3), (4), (5), (6), (7)
  • session and
  • SQL statements for (1), (2), (3)
  • transaction and (1), (2)
  • types of (1), (2)
  • update (1), (2), (3), (4), (5), (6), (7), (8), (9)
  • where stored (1), (2)
  • with hold.
    • See also Cursor, hold.
• Cursor function
• Cursor mode (1), (2)

• Data alignment.
  • See also Type alignment.
• Data and/or time data
  • binary representation
  • obtaining type information
• Data conversion
  • byte order (1), (2), (3), (4), (5), (6), (7), (8), (9), (10)
  • ESQL/C library functions for
  • functions for (1), (2), (3), (4), (5), (6)
  • LO handles
  • mi_char values
  • mi_date to mi_datetime
  • mi_date values
  • mi_datetime extension (1), (2)
  • mi_datetime to mi_date
  • mi_datetime values
  • mi_decimal values
  • mi_int8 values
  • mi_interval extension (1), (2)
  • mi_interval values
  • mi_money values
  • mi_string values
  • portability and
  • type alignment (1), (2), (3), (4), (5), (6), (7), (8), (9), (10)
• Data integrity
• Data pointer.
  • See also Varying-length structure, data pointer.
• Data portion.
  • See also Varying-length structure, data portion.
• Data sources
  • XA-compliant (1), (2)
• Data type.
  • See also DataBlade API data type; SQL data type.
• Data type descriptor
• Database
  • determining if ANSI compliant
  • dropping
  • obtaining name of (1), (2), (3)
  • opening in exclusive mode
  • options
  • restrictions in UDR
  • smart large objects in
  • specifying for connection (1), (2), (3)
  • using transactions
• Database-information descriptor
  • defined (1), (2)
  • fields of
  • populating (1), (2)
  • setting
• Database locale (1), (2), (3), (4)
• Database parameter
  • current
  • default
  • obtaining (1), (2), (3)
  • setting
  • system-default
  • user-defined
  • using
• Database server
  • See also DATABASE statement
  • connecting to.
    • See also Connection.
  • default
  • environment of.
    • See also Server environment.
  • initializing
  • instance of.
    • See also Database server instance.
  • obtaining name of (1), (2), (3)
  • port name (1), (2)
  • remote
  • shared memory of
  • specifying
  • virtual-processor classes
• Database server exception
  • See also Runtime error; Exception handling; MI_Exception event; Warning.
  • callback for
  • defined
  • exception levels
  • handling
  • in callbacks
  • memory duration and
  • raising
  • runtime errors
  • status variables for
  • tracing
  • warnings
• Database server instance
  • defined (1), (2)
  • memory duration for
  • server environment.
    • See also Server environment.
• Database server session.
  • See also Session.
• DATABASE statement
• Database utility
  • dbexport
  • dbimport
  • dbschema
• DataBlade API
  • advanced features
  • client-side
  • data types
  • defined (1), (2)
  • for client LIBMI applications
  • for UDRs
  • functions
  • header files (1), (2)
  • IBM Informix GLS functions
  • initializing (1), (2)
  • library errors
  • portability of (1), (2), (3), (4)
  • server-side
  • types of programs
  • uses of
• DataBlade API data structure
  • See also DataBlade API data type; Structure.
  • current memory duration
  • list of
  • MI_COLL_DESC (1), (2)
  • MI_COLLECTION (1), (2)
  • MI_CONNECTION (1), (2)
  • MI_CONNECTION_INFO (1), (2)
  • MI_DATABASE_INFO (1), (2)
  • MI_ERROR_DESC (1), (2)
  • MI_FPARAM (1), (2)
  • MI_FUNC_DESC (1), (2)
  • MI_FUNCARG (1), (2)
  • MI_LO_FD
  • MI_LO_HANDLE (1), (2)
  • MI_LO_SPEC (1), (2), (3)
  • MI_LO_STAT (1), (2), (3)
  • MI_PARAMETER_INFO (1), (2)
  • MI_ROW (1), (2)
  • MI_ROW_DESC (1), (2), (3)
  • MI_SAVE_SET (1), (2)
  • MI_STATEMENT (1), (2)
  • mi_statret
  • mi_stream
  • MI_STREAM (1), (2), (3)
  • MI_TRANSITION_DESC (1), (2)
  • MI_TYPE_DESC (1), (2)
  • MI_TYPEID (1), (2)
  • PER_COMMAND memory duration
  • PER_ROUTINE memory duration
  • PER_SESSION memory duration
  • PER_STMT_EXEC memory duration
  • PER_SYSTEM memory duration
  • PER_TRANSACTION memory duration (1), (2)
  • stream-operations
• DataBlade API data type (1), (2)
  • See also DataBlade API data structure., SQL data type; DataBlade API data structure.
  • alignment of
  • byte data types
  • C data type correspondence
  • character data types
  • data structures
  • eight-byte integer
  • fixed-point
  • floating-point
  • four-byte integer
  • generic
  • header file for
  • integer
  • length of
  • list of
  • locale-specific (1), (2), (3), (4), (5), (6), (7), (8)
  • maximum length of
  • mi_bitvarying (1), (2), (3)
  • mi_boolean (1), (2)
  • mi_char (1), (2)
  • mi_char1 (1), (2)
  • MI_COLLECTION (1), (2)
  • mi_date (1), (2), (3)
  • mi_datetime (1), (2), (3), (4)
  • MI_DATUM (1), (2)
  • mi_decimal (1), (2), (3), (4), (5), (6)
  • mi_double_precision (1), (2), (3)
  • mi_impexp (1), (2), (3), (4)
  • mi_impexpbin (1), (2), (3), (4)
  • mi_int1 (1), (2), (3)
  • mi_int8 (1), (2), (3)
  • mi_integer (1), (2), (3), (4)
  • mi_interval (1), (2), (3), (4)
  • mi_lvarchar (1), (2), (3), (4)
  • mi_money (1), (2), (3)
  • mi_numeric (1), (2)
  • mi_pointer (1), (2), (3)
  • mi_real (1), (2), (3), (4)
  • MI_ROW (1), (2), (3)
  • mi_sendrecv (1), (2), (3), (4)
  • mi_sint1 (1), (2), (3)
  • mi_smallint (1), (2), (3)
  • mi_string (1), (2)
  • mi_unsigned_char1 (1), (2), (3)
  • mi_unsigned_int8 (1), (2), (3)
  • mi_unsigned_integer (1), (2), (3), (4)
  • mi_unsigned_smallint (1), (2), (3), (4)
  • mi_wchar
  • name of (1), (2)
  • NULL-valued pointer
  • obtaining information about
  • one-byte integer
  • owner of
  • passing by reference.
    • See also Pass-by-reference passing mechanism.
  • passing by value.
    • See also Pass-by-value passing mechanism.
  • passing mechanism.
    • See also Passing mechanism.
  • portability of (1), (2), (3), (4), (5), (6), (7)
  • precision of (1), (2), (3), (4), (5), (6)
  • public
  • qualifier of (1), (2)
  • scale of
  • smart-large-object (1), (2), (3)
  • SQL data type correspondence
  • support
  • transferring between computers (1), (2), (3), (4), (5), (6), (7), (8), (9), (10), (11)
  • two-byte integer
  • type descriptor.
    • See also Type descriptor.
  • type identifier.
    • See also Type identifier.
• DataBlade API function library
  • See also ESQL/C function library; Informix GLS library; and individual function names.
  • byte functions
  • callback-function functions (1), (2)
  • categories of functions
  • character-transfer functions
  • code-set-conversion functions
  • collection functions
  • column-information functions (1), (2)
  • column-value functions
  • connection functions
  • connection-parameter functions
  • connection-user-data functions
  • data-conversion functions (1), (2), (3), (4), (5)
  • database-parameter functions
  • date- and/or time-conversion functions
  • date-conversion functions
  • decimal-conversion functions
  • error-descriptor functions (1), (2), (3)
  • exception handling for (1), (2), (3)
  • executable-statement functions
  • Fastpath-interface functions
  • file-access functions (1), (2), (3), (4), (5), (6), (7)
  • freeing memory
  • function-descriptor functions
  • indicating default values
  • indicating errors (1), (2), (3), (4)
  • initialization functions
  • input-parameter functions (1), (2)
  • LO-handle functions
  • LO-specification functions (1), (2), (3), (4)
  • memory duration and
  • memory management for
  • memory-management functions (1), (2), (3), (4), (5), (6), (7), (8)
  • MI_FPARAM accessor functions (1), (2), (3), (4)
  • MI_FPARAM allocation functions
  • MI_FUNCARG accessor functions (1), (2), (3)
  • non-PDQ-threadsafe functions
  • NULL-value functions
  • prepared-statement functions (1), (2), (3)
  • result-information functions
  • return values (1), (2)
  • row-structure functions
  • save-set functions (1), (2)
  • serial functions
  • session-parameter functions
  • smart-large-object creation functions (1), (2)
  • smart-large-object file-conversion functions
  • smart-large-object I/O functions (1), (2), (3)
  • smart-large-object status functions (1), (2)
  • state-change function
  • statement-execution functions (1), (2), (3)
  • statement-information functions (1), (2)
  • stream I/O functions (1), (2)
  • stream-transfer functions
  • string-conversion functions
  • thread-management functions
  • thread-yielding functions
  • tracing functions (1), (2), (3)
  • type-descriptor accessor functions (1), (2)
  • type-identifier accessor functions
  • type-transfer functions (1), (2), (3), (4), (5), (6), (7), (8), (9), (10), (11), (12)
  • VP-environment functions
• DataBlade API module
  • See also Client LIBMI application; User-defined routine (UDR).
  • calling UDRs within
  • defined
  • event handling
  • including mi.h (1), (2), (3)
  • including minmmem.h
  • internationalization of
• DataBlade API module code conventions
• DataBlade API support data type
  • list of
  • MI_CALLBACK_STATUS (1), (2)
  • MI_CURSOR_ACTION (1), (2), (3)
  • MI_EVENT_TYPE (1), (2)
  • MI_FUNCARG (1), (2)
  • mi_funcid (1), (2)
  • MI_ID
  • MI_MEMORY_DURATION (1), (2), (3)
  • MI_SETREQUEST (1), (2)
  • MI_TRANSITION_TYPE (1), (2)
  • MI_UDR_TYPE
• DataBlade module
  • creating
  • defined
  • extending
  • UDRs with (1), (2)
• DataBlade UDR.
  • See also User-defined routine (UDR).
• Date and/or time data
  • arithmetic operations on
  • binary representation (1), (2), (3)
  • byte order
  • data conversion of (1), (2)
  • in opaque type (1), (2), (3), (4), (5)
  • macros for (1), (2)
  • support for
  • text representation (1), (2), (3)
  • transferring
  • type alignment
• Date and/or time string
  • converting from mi_datetime (1), (2)
  • converting to mi_datetime (1), (2)
  • data conversion of
  • defined
  • end-user format
  • format of
• Date data
  • See also DATE data type.
  • binary representation (1), (2), (3)
  • byte order
  • data conversion of (1), (2)
  • end-user format for
  • in opaque type (1), (2), (3), (4), (5)
  • operations on
  • support for
  • text representation (1), (2), (3)
  • transferring
  • type alignment
• DATE data type
  • See also mi_date data type.
  • corresponding DataBlade API data type (1), (2), (3)
  • data conversion of
  • DataBlade API functions for (1), (2)
  • ESQL/C functions for (1), (2), (3)
  • format of (1), (2)
  • functions for (1), (2), (3)
  • GLS library functions for
  • operations on
• date data type (ESQL/C).
  • See also mi_date data type.
• Date-formatting string
• Date string
  • converting from mi_date (1), (2), (3)
  • converting to mi_date (1), (2), (3)
  • data conversion of
  • defined
  • format of
• Date/time data
  • See also DATETIME data type; INTERVAL data type.
  • data conversion of
• Date/time string
  • ANSI SQL standards format
  • converting from mi_datetime
  • converting to mi_datetime
• DATE value, passing mechanism for
• DATETIME data type
  • See also mi_datetime data type.
  • ANSI SQL standards format (1), (2), (3), (4)
  • arithmetic operations on
  • corresponding DataBlade API data type (1), (2), (3)
  • data conversion of (1), (2), (3)
  • DataBlade API functions for
  • ESQL/C functions for (1), (2)
  • extending
  • format of (1), (2)
  • functions for (1), (2), (3)
  • GLS library functions for
  • inserting (1), (2)
  • macros
  • precision of
  • qualifiers (1), (2), (3), (4)
  • role of datetime.h
  • scale of
  • selecting (1), (2)
• datetime data type (ESQL/C).
  • See also mi_datetime data type.
• datetime.h header file (1), (2), (3)
• Datum (1), (2)
  • See also MI_DATUM data type.
• DB-Access utility
• DB_LOCALE environment variable (1), (2), (3), (4)
• DBDATE environment variable (1), (2), (3)
• dbexport utility
• dbimport utility
• DBMONEY environment variable (1), (2), (3), (4)
• dbschema utility
• DBTIME environment variable (1), (2)
• Debugger
  • hints for
  • running session of
  • setting breakpoints
  • starting
  • using
• dec_t structure (1), (2), (3)
• decadd() function
• deccmp() function
• deccopy() function
• deccvasc() function
• deccvdbl() function
• deccvint() function
• deccvlong() function
• decdiv() function
• dececvt() function
• decfvct() function
• Decimal data
  • arithmetic operations on
  • binary representation (1), (2), (3), (4)
  • end-user format for
  • in opaque type (1), (2), (3), (4), (5), (6), (7)
  • text representation (1), (2), (3), (4)
• DECIMAL data type
  • See also mi_decimal data type; Precision; Scale.
  • arithmetic operations on
  • corresponding DataBlade API data type (1), (2), (3)
  • data conversion of
  • DataBlade API functions for (1), (2), (3)
  • declaring variables for
  • ESQL/C functions for (1), (2), (3)
  • format of (1), (2), (3)
  • formatting
  • functions for (1), (2), (3), (4)
  • getting column value for
  • GLS library functions for
  • macros
  • precision of (1), (2), (3), (4)
  • role of decimal.h (1), (2)
  • scale of (1), (2)
• decimal data type (ESQL/C).
  • See also mi_decimal data type.
• decimal.h header file (1), (2), (3)
• Decimal separator (1), (2), (3)
• Decimal string
  • converting from mi_decimal
  • converting to mi_decimal
  • creating formatted
  • data conversion of
  • defined
  • format of
• DECLEN decimal macro
• decmul() function
• DECPREC decimal macro
• decround() function
• decsub() function
• dectoasc() function
• dectodbl() function
• dectoint() function
• dectolong() function
• dectrunc() function
• Default connection
• Default locale
• DELETE statement
  • calling a UDR (1), (2), (3)
  • obtaining results of
  • opaque types
  • sending to database server
  • smart large object and
  • WHERE CURRENT OF clause (1), (2), (3)
• Dependencies, software
• destroy() support function
  • decrementing the reference count
  • defined (1), (2)
  • deleting a smart large object
• Destructor
  • collection descriptor (1), (2), (3), (4)
  • collection structure (1), (2)
  • connection descriptor (1), (2), (3), (4)
  • current memory duration
  • defined
  • error descriptor (1), (2)
  • file descriptor (1), (2)
  • function descriptor (1), (2), (3)
  • LO file descriptor
  • LO handle (1), (2), (3)
  • LO-specification structure (1), (2), (3)
  • LO-status structure (1), (2), (3)
  • MI_FPARAM (1), (2), (3), (4)
  • named memory (1), (2)
  • PER_COMMAND duration
  • PER_ROUTINE duration
  • PER_SESSION duration
  • PER_STMT_EXEC duration
  • routine argument
  • routine return value
  • row descriptor (1), (2), (3)
  • row structure (1), (2), (3)
  • save-set structure (1), (2), (3)
  • session-duration connection descriptor (1), (2)
  • session-duration function descriptor (1), (2)
  • statement descriptor (1), (2), (3), (4), (5)
  • stream descriptor (1), (2), (3)
  • user memory (1), (2), (3), (4), (5)
  • varying-length structure (1), (2), (3)
• Directory.
  • See also Working directory.
• Disabilities, visual
  • reading syntax diagrams
• Distinct data type
  • binary representation
  • checking type identifier for
  • obtaining column value for
  • obtaining source type
  • text representation
• dlclose() system call
• dlerror() system call
• DLL.
  • See also Dynamic link library.
• dlopen() system call
• dlsym() system call
• Documentation, types of
  • machine notes
  • online manuals
  • printed manuals
• Documentation conventions
• Documentation Notes
• Documentation set of all manuals
• Dollar sign ($) (1), (2)
• Dotted decimal format of syntax diagrams
• double (C) data type
  • See also mi_double_precision data type.
  • character conversion
  • corresponding DataBlade API data type (1), (2)
  • mi_decimal conversion (1), (2)
  • mi_int8 conversion (1), (2)
• DOUBLE PRECISION data type.
  • See also FLOAT data type.
• DPRINTF tracing function
• DROP DATABASE statement (1), (2), (3)
• DROP FUNCTION statement (1), (2), (3)
• DROP PROCEDURE statement (1), (2), (3)
• DROP ROUTINE statement (1), (2), (3)
• DROP TABLE statement (1), (2)
• DROP XADATASOURCE statement
• DROP XADATASOURCE TYPE statement
• dtaddinv() function
• dtcurrent() function
• dtcvasc() function (1), (2)
• dtcvfmtasc() function
• dtextend() function (1), (2), (3)
• dtime_t structure (1), (2), (3)
• dtime_t typedef
• dtsub() function
• dtsubinv() function
• dttoasc() function (1), (2)
• dttofmtasc() function
• Dynamic link library (1), (2), (3)
  • See also Shared-object file.

• en_us.8859-1 locale
• End-of-session callback (1), (2), (3), (4), (5), (6), (7)
  • See also MI_EVENT_END_SESSION event type.
  • PER_SESSION memory and
• End-of-statement callback (1), (2), (3), (4), (5), (6), (7), (8), (9)
  • See also MI_EVENT_END_STMT event type.
  • PER_STMT_EXEC memory and (1), (2)
• End-of-transaction callback (1), (2), (3), (4), (5), (6), (7), (8), (9), (10), (11)
  • See also MI_EVENT_END_XACT event type.
  • PER_TRANSACTION memory and
• End-user format
  • date
  • date and/or time
  • monetary
  • numeric (1), (2), (3)
• End-user routine (1), (2), (3)
• Environment variable
  • as part of server environment
  • CLIENT_LOCALE
  • DB_LOCALE (1), (2), (3)
  • DBDATE (1), (2), (3)
  • DBMONEY (1), (2), (3), (4)
  • DBTIME (1), (2)
  • GL_DATE (1), (2), (3), (4)
  • in file pathname (1), (2)
  • in UDR pathname
  • INFORMIXDIR
  • INFORMIXSERVER (1), (2), (3)
  • obtaining value of
  • SERVER_LOCALE (1), (2), (3)
• Environment variables
• errno system variable
• Error
  • See also Exception; Runtime error.
  • client LIBMI
• Error descriptor
  • accessing
  • constructor for (1), (2)
  • copying
  • defined (1), (2)
  • destructor for (1), (2)
  • error level
  • exception level
  • functions for (1), (2), (3)
  • information in
  • memory duration of (1), (2)
  • message text
  • SQLCODE status value
  • SQLSTATE status value
  • types of errors
  • types of events
• Error handling (client) (1), (2), (3)
  • See also Event handling; Warning.
• Error level
• Error message, internationalizing
• Error messages
• ESQL/C function library
  • See also DataBlade API function library; Informix GLS library; and individual function names.
  • byte functions (1), (2)
  • categories of functions
  • character-type functions (1), (2), (3)
  • data-conversion functions (1), (2), (3), (4)
  • date- and/or time-conversion functions
  • date- and/or time-operation functions
  • date-conversion functions
  • date-operation functions
  • DATE-type functions (1), (2), (3)
  • DATETIME-type functions (1), (2), (3), (4)
  • decimal-conversion functions
  • decimal-operation functions
  • DECIMAL-type functions (1), (2), (3), (4), (5)
  • INT8-conversion functions
  • INT8-type functions (1), (2)
  • INTERVAL-type functions (1), (2), (3)
  • MONEY-type functions.
    • See also ESQL/C function library, DECIMAL-type functions.
  • numeric-formatting functions
  • string-conversion functions
• ESQL/C header files
• Event
  • See also Client LIBMI error; Database server exception; State-transition event.
  • catching
  • client LIBMI error
  • database server exception
  • defined
  • handling of.
    • See also Event handling.
  • information about
  • state-transition event
  • structures for
  • throwing
  • types of.
    • See also Event type.
• Event handling
  • See also Error handling (client); Exception handling.
  • default behavior
  • defined
  • in C UDRs (1), (2), (3)
  • in client LIBMI applications (1), (2)
  • invoking a callback
• Event type
  • groups of
  • list of
  • MI_All_Events deprecated
  • MI_Client_Library_Error (1), (2)
  • MI_EVENT_COMMIT_ABORT (1), (2), (3), (4), (5), (6), (7), (8), (9), (10), (11)
  • MI_EVENT_END_SESSION (1), (2), (3), (4), (5), (6), (7), (8)
  • MI_EVENT_END_STMT (1), (2), (3), (4), (5), (6), (7), (8), (9)
  • MI_EVENT_END_XACT (1), (2), (3), (4), (5), (6), (7), (8), (9)
  • MI_EVENT_POST_XACT (1), (2), (3), (4), (5), (6), (7), (8), (9), (10)
  • MI_EVENT_SAVEPOINT (1), (2), (3), (4), (5), (6), (7), (8), (9), (10), (11)
  • MI_Exception (1), (2)
  • MI_Xact_State_Change
• EVP.
  • See also User-defined virtual processor.
• Exception.
  • See also Database server exception; Error; Warning.
• Exception callback (1), (2), (3), (4)
• Exception handling
  • See also Event handling; NOT FOUND condition; Runtime error; Warning.
  • continuing with
  • determining how exception is processed
  • handling in a callback
  • in C UDRs (1), (2)
  • in client LIBMI applications (1), (2)
  • in DataBlade API functions (1), (2), (3)
  • multiple
  • NOT FOUND condition (1), (2), (3)
  • providing
  • raising an exception
  • returning error information
  • runtime errors (1), (2)
  • status variables for
  • user-defined error structure
  • using
  • warning conditions (1), (2)
  • with SQLCODE
  • with SQLSTATE
• Exception level (1), (2)
  • See also MI_EXCEPTION exception level; MI_MESSAGE exception level.
• Exception message
  • adding
  • custom (1), (2)
  • internationalized
  • literal
  • parameters in
  • specifying
• exec() system call (1), (2), (3)
• EXECUTE FUNCTION statement
  • See also Cursor; Query; User-defined function.
  • associated with a cursor
  • calling a UDR (1), (2), (3)
  • obtaining results of
  • sending to database server (1), (2), (3)
• EXECUTE PROCEDURE statement (1), (2), (3), (4), (5)
  • See also User-defined procedure.
• exit() system call
• EXP VP.
  • See also User-defined virtual processor.
• Expensive UDR
  • argument data type (1), (2), (3)
  • argument length (1), (2)
  • argument type
  • column number (1), (2)
  • constant value
  • cost
  • defined
  • determining if argument is NULL
  • distribution information (1), (2)
  • table identifier (1), (2)
• Explicit cast (1), (2), (3), (4), (5), (6)
• Explicit cursor
  • See also Cursor; Implicit cursor.
  • characteristics of (1), (2)
  • closing
  • defining (1), (2), (3)
  • fetching rows into
  • freeing (1), (2)
  • opening
  • where stored
• Explicit transaction (1), (2)
• Export support function
  • as cast function
  • defined (1), (2)
  • internationalizing
• Exportbin support function
  • as cast function
  • defined (1), (2)
• Extension VP.
  • See also User-defined virtual processor.
• External function.
  • See also User-defined function.
• External-library routines
  • avoidance of
  • unsafe use of
• External procedure.
  • See also User-defined procedure.
• External routine (1), (2)
  • See also User-defined routine (UDR).

• Failure.
  • See also Error; Runtime error.
• Fastpath interface
  • checking for commutator function
  • checking for negator function
  • checking for NULL arguments
  • checking for variant function
  • determining if UDR handles NULLs
  • executing cast functions
  • executing UDRs
  • functions of
  • look-up functions (1), (2), (3), (4), (5), (6)
  • looking up cast functions
  • looking up UDRs
  • obtaining a function descriptor
  • obtaining MI_FPARAM
  • obtaining routine identifier
  • releasing resources
  • user-allocated MI_FPARAM
  • uses of (1), (2)
  • using
• fcntl.h header file
• File
  • copy
  • makefile
  • message log.
    • See also Message log file.
  • online.log.
    • See also Message log file.
  • operating-system (1), (2)
    • See also Operating-system file.
  • seek position
    • obtaining (1), (2), (3)
    • setting (1), (2), (3)
  • shared-object.
    • See also Shared-object file.
  • trace-output
• File descriptor
  • See also LO file descriptor; Operating-system file.
  • constructor for (1), (2), (3)
  • defined
  • destructor for (1), (2)
  • freeing
  • memory duration of (1), (2), (3)
• File extension
  • .bld
  • .c
  • .dll
  • .dsw
  • .mak
  • .o (1), (2)
  • .so
  • .trc
• File management
  • See also Operating-system file.
  • file-access functions
  • filenames
  • in C UDRs (1), (2), (3)
  • parallelizable UDR and
  • sharing files
  • smart large objects and (1), (2)
• File stream
  • closing
  • data length
  • defined
  • getting
    • seek position of (1), (2)
  • opening
  • reading from
  • setting
    • seek position of (1), (2)
  • stream I/O functions for
  • writing to
• FINAL aggregate support function (1), (2), (3), (4)
• fixchar data type (ESQL/C).
  • See also mi_string data type.
• Fixed and Known Defects File
• Fixed-length data.
  • See also DECIMAL data type; MONEY data type.
• Fixed-length opaque data type
  • See also Opaque data type; Varying-length opaque data type.
  • as routine argument
  • as routine return value
  • binary representation
  • defining
  • passing mechanism
  • registering
  • text representation
• Fixed-point data
  • binary representation
  • byte order
  • data conversion of (1), (2)
  • decimal data
  • formatting
  • in opaque type (1), (2), (3)
  • macros for
  • monetary data
  • obtaining type information
  • portability of
  • support for
  • text representation
  • transferring
  • type alignment
• float (C) data type
  • See also mi_real data type.
  • corresponding DataBlade API data type (1), (2)
  • mi_int8 conversion (1), (2)
• FLOAT data type
  • See also mi_double_precision data type.
  • corresponding DataBlade API data type (1), (2)
  • DataBlade API functions for
  • declaring variables for
  • format of
  • functions for
  • obtaining column value for
• Floating-point data
  • See also DECIMAL data type; FLOAT data type; SMALLFLOAT data type.
  • binary representation (1), (2)
  • byte order (1), (2)
  • data conversion of (1), (2)
  • formatting
  • in opaque type (1), (2), (3)
  • obtaining type information
  • portability of
  • support for
  • text representation (1), (2)
  • transferring
  • type alignment
• fopen() system call
• fork() system call (1), (2)
• Formatting string (1), (2)
• free() system call (1), (2)
• Function descriptor
  • accessor functions
  • caching
  • constructor for (1), (2)
  • defined (1), (2)
  • destructor for (1), (2), (3)
  • determining commutator function
  • determining negator function
  • determining variant function
  • executing a UDR
  • for cast function
  • for UDR
  • freeing (1), (2)
  • memory duration of (1), (2), (3), (4), (5), (6)
  • MI_FPARAM structure (1), (2), (3)
  • obtaining
  • obtaining information in
  • releasing resources for
  • reusing
  • routine identifier
  • routine NULL arguments
  • routine sequence and (1), (2), (3)
  • session-duration.
    • See also Session-duration function descriptor.
  • where stored (1), (2)
• Function identifier.
  • See also Routine identifier.
• Function-parameter structure.
  • See also MI_FPARAM structure.
• Function return value.
  • See also Routine return value.
• Function Syntax Conventions

• getmsg() system call
• GL_DATE environment variable (1), (2), (3), (4)
• GL_DPRINTF tracing DataBlade API function
• GL_DPRINTF tracing function
• gl_tprintf() tracing function (1), (2)
• Global Language Support (GLS) (1), (2)
  • See also Code-set conversion; Locale.
  • character data types for routine arguments
  • character data types for variables (1), (2), (3)
  • code-set conversion for opaque types
  • custom messages (1), (2)
  • session environment and
  • wide-character support
• Global transaction ID
• Global variable (1), (2), (3), (4)
• GLS.
  • See also Global Language Support.
• GRANT statement (1), (2), (3), (4), (5)

• HANDLESNULLS routine modifier (1), (2), (3), (4), (5)
  • statcollect() function
• HDR.
  • See also High-Availability Data Replication.
• Header file
  • See also individual header filenames.
  • advanced
  • datetime.h (1), (2)
  • decimal.h (1), (2)
  • ESQL/C (1), (2)
  • fcntl.h
  • int8.h (1), (2)
  • list of
  • location of
  • memdur.h (1), (2)
  • mi.h (1), (2)
  • miconv.h
  • milib.h
  • milo.h (1), (2)
  • minmdur.h (1), (2)
  • minmmem.h (1), (2), (3), (4)
  • minmprot.h (1), (2), (3)
  • mistream.h (1), (2), (3), (4), (5)
  • mistrmtype.h (1), (2)
  • mistrmutil.h (1), (2)
  • mitrace.h (1), (2), (3)
  • mitypes.h (1), (2)
  • private
  • sqlca.h
  • sqlda.h
  • sqlhdr.h
  • sqlstype.h
  • sqltypes.h
  • sqlxtype.h
  • stddef.h
  • varchar.h
• Heap space (1), (2), (3), (4), (5), (6)
• Help
• High-Availability Data Replication
  • determining status
• Hyphen (-), as formatting character

• IBM Informix GLS library (1), (2)
• ifx_dececvt() function
• ifx_decfcvt() function
• ifx_int8_t structure (1), (2)
• ifx_int8add() function
• ifx_int8cmp() function
• ifx_int8copy() function
• ifx_int8cvasc() function
• ifx_int8cvdbl() function
• ifx_int8cvdec() function
• ifx_int8cvflt() function
• ifx_int8cvint() function
• ifx_int8cvlong() function
• ifx_int8div() function
• ifx_int8mul() function
• ifx_int8sub() function
• ifx_int8toasc() function
• ifx_int8todbl() function
• ifx_int8todec() function
• ifx_int8toflt() function
• ifx_int8toint() function
• ifx_int8tolong() function
• ifx_replace_module() SQL function
• ifx_unload_module() SQL procedure
• Ill-behaved routine (1), (2), (3), (4)
  • See also Well-behaved routine.
• image sample opaque type
  • export function (1), (2)
  • import function
  • importbin function
  • input function
  • internal representation
  • output function
  • receive function
  • registering
  • send function
  • support functions
• IMPEXP data type
  • See also mi_impexp data type.
  • casting from
  • casting from opaque type
  • corresponding DataBlade API data type
  • defined (1), (2)
• IMPEXPBIN data type
  • See also mi_impexpbin data type.
  • casting from
  • casting from opaque type
  • corresponding DataBlade API data type
  • defined (1), (2)
• Implicit cast (1), (2), (3), (4), (5)
• Implicit cursor
  • See also Cursor; Explicit cursor.
  • characteristics of
  • closing (1), (2)
  • defined
  • freeing (1), (2)
  • opening
  • processing results of
  • where stored
• Implicit transaction
• Import support function
  • as cast function
  • defined (1), (2)
  • internationalizing
• Importbin support function
  • defined (1), (2)
• Importbinary support function
  • as cast function
• incvasc() function
• incvfmtasc() function
• Industry standards, compliance with
• Informix Dynamic Server documentation set
• Informix-ESQL/C.
  • See also ESQL/C.
• informix user account (1), (2)
• INFORMIXDIR/bin directory
• INFORMIXDIR environment variable
• INFORMIXSERVER environment variable (1), (2), (3)
• INIT aggregate support function (1), (2), (3), (4), (5), (6)
• Input parameter
  • accessor functions
  • assigning value to (1), (2), (3)
  • control mode
  • data type of value
  • defined
  • handling NULL value
  • length of value
  • MI_DATUM value (1), (2)
  • NOT NULL constraint (1), (2), (3)
  • number of
  • obtaining information for
  • parameter identifier
  • precision of (1), (2), (3), (4), (5), (6), (7), (8), (9), (10), (11)
  • restrictions on use
  • scale of (1), (2), (3), (4), (5), (6), (7)
  • specifying in SQL statement
  • type identifier of (1), (2)
  • type name of (1), (2)
  • value of
• Input support function
  • as cast function
  • conversion functions in
  • defined (1), (2)
  • external format in
  • handling character data (1), (2)
  • handling date and/or time data (1), (2)
  • handling date data (1), (2)
  • handling decimal data (1), (2)
  • handling smart large object (1), (2)
  • internationalizing
• INSERT statement
  • calling a UDR (1), (2)
  • obtaining results of
  • opaque types (1), (2), (3)
  • parameter information for
  • sending to database server (1), (2)
  • smart large object (1), (2)
• Installation Guides
• Instance.
  • See also Routine instance.
• int (C) data type (1), (2), (3), (4)
  • See also mi_integer data type.
• int (four-byte) data type
  • corresponding DataBlade API data type (1), (2)
  • mi_decimal conversion (1), (2)
  • mi_int8 conversion (1), (2)
• int (two-byte) data type
  • corresponding DataBlade API data type (1), (2)
  • mi_decimal conversion (1), (2)
  • mi_int8 conversion (1), (2)
• INT8 data type
  • See also mi_int8 data type; SERIAL8 data type.
  • arithmetic operations on
  • corresponding DataBlade API data type (1), (2), (3)
  • data conversion of
  • ESQL/C functions for (1), (2)
  • format of (1), (2), (3)
  • functions for (1), (2), (3), (4)
  • obtaining column value for
  • role of int8.h (1), (2)
• int8 data type (ESQL/C).
  • See also mi_int8 data type.
• int8.h header file (1), (2), (3)
• Integer data
  • arithmetic operations on
  • binary representation (1), (2), (3)
  • byte order (1), (2), (3)
  • data conversion of (1), (2), (3), (4)
  • eight-byte
  • end-user format for
  • four-byte (1), (2)
  • in opaque type (1), (2), (3), (4), (5), (6)
  • one-byte
  • portability of (1), (2), (3)
  • support for
  • text representation (1), (2)
  • transferring (1), (2), (3)
  • two-byte (1), (2)
  • type alignment (1), (2), (3)
• INTEGER data type
  • See also mi_integer data type; SERIAL data type.
  • corresponding DataBlade API data type (1), (2), (3)
  • format of (1), (2)
  • obtaining column value for
• Integer string
• INTEGER value, passing mechanism for
• Internal format.
  • See also Binary representation.
• INTERNAL routine modifier
• INTERNALLENGTH opaque-type modifier (1), (2)
• Internationalization
  • DataBlade API modules and
  • IBM Informix GLS library (1), (2)
  • of error messages
• Interval data
  • binary representation (1), (2), (3)
  • byte order
  • data conversion of (1), (2)
  • in opaque type (1), (2), (3), (4), (5)
  • support for
  • text representation (1), (2)
  • transferring
  • type alignment
• INTERVAL data type
  • See also mi_ interval data type.
  • ANSI SQL standards format (1), (2), (3), (4)
  • arithmetic operations on
  • classes of (1), (2)
  • corresponding DataBlade API data type (1), (2), (3)
  • data conversion of (1), (2), (3)
  • DataBlade API functions for
  • ESQL/C functions for (1), (2)
  • extending
  • format of (1), (2)
  • functions for (1), (2), (3)
  • inserting (1), (2)
  • macros
  • precision of
  • qualifiers (1), (2), (3)
  • role of datetime.h
  • scale of
  • selecting (1), (2)
• interval data type (ESQL/C).
  • See also mi_interval data type.
• Interval string
  • ANSI SQL standards format
  • converting from mi_interval (1), (2), (3)
  • converting to mi_interval (1), (2), (3)
  • data conversion of
  • end-user format
  • format of
• intoasc() function
• intofmtasc() function
• intrvl_t structure (1), (2), (3)
• intrvl_t typedef
• invdivdbl() function
• invdivinv() function
• invextend() function (1), (2)
• invmuldbl() function
• Invocation.
  • See also Routine invocation.
• ISAM error code (1), (2)
• ISO 8859-1 code set
• ITER aggregate support function (1), (2), (3)
• Iterator-completion flag (1), (2), (3), (4)
• Iterator function
  • calling
  • changing global information
  • creating
  • defined (1), (2), (3)
  • end condition
  • executing (1), (2)
  • initializing
  • invocations
  • iterator-completion flag (1), (2), (3)
  • iterator status (1), (2), (3)
  • limitations
  • registering
  • releasing resources
  • restriction with Fastpath
  • returning one item
  • routine-state information
  • statcollect() as
• ITERATOR routine modifier (1), (2), (3), (4)
• Iterator status (1), (2), (3), (4)

• Jagged rows (1), (2), (3), (4)

• Keywords
  • in syntax diagrams

• Large object.
  • See also Simple large object; Smart large object.
• ldchar() function
• Less than (
• Lightweight I/O (1), (2)
• Linux operating system, safe system calls (1), (2)
• LIST data type
  • See also SQL data type.
  • checking type identifier for
  • corresponding DataBlade API data type
  • format of
  • obtaining column value for
• Literal value.
  • See also Text representation.
• LO
  • seek position
    • defined
    • initial
    • obtaining (1), (2)
    • read operations and (1), (2)
    • setting (1), (2)
    • write operations and (1), (2)
• LO file descriptor
  • constructor for
  • declaring
  • defined (1), (2), (3)
  • destructor for
  • freeing (1), (2)
  • functions for
  • memory duration of.
    • See also LO file descriptor, scope of.
  • obtaining (1), (2), (3)
  • scope of (1), (2)
• LO handle
  • allocating (1), (2)
  • binary representation (1), (2)
  • byte order
  • character conversion
  • constructor for (1), (2), (3)
  • copying (1), (2)
  • creating
  • declaring
  • defined (1), (2), (3), (4), (5)
  • deleting from a database (1), (2), (3)
  • destructor for (1), (2), (3)
  • format of (1), (2), (3)
  • freeing
  • functions for
  • in BLOB column (1), (2), (3)
  • in CLOB column (1), (2), (3)
  • in INSERT (1), (2)
  • in opaque data type
  • in UPDATE (1), (2), (3)
  • invalidating
  • memory duration of (1), (2), (3), (4), (5)
  • obtaining (1), (2)
  • portability of
  • receiving from client
  • reference count and (1), (2), (3)
  • representations of (1), (2)
  • selecting from a database (1), (2), (3)
  • sending to client
  • storing in a database (1), (2), (3), (4)
  • text representation (1), (2), (3)
  • transferring between computers
  • type alignment
  • valid
  • validating
• LO-specification structure
  • accessor functions (1), (2), (3), (4)
  • allocating
  • allocation extent size
  • attributes flag
  • constructor for (1), (2), (3)
  • contents of
  • creating
  • declaring (1), (2)
  • default-open-mode flag
  • defined (1), (2), (3)
  • destructor for (1), (2), (3)
  • disk-storage information
  • estimated size
  • freeing
  • initializing (1), (2)
  • maximum size
  • memory duration of (1), (2), (3), (4)
  • obtaining
  • sbspace name
  • storage characteristics
• LO-status structure
  • accessor functions (1), (2)
  • allocating
  • constructor for (1), (2), (3)
  • contents of
  • creating
  • defined (1), (2), (3)
  • destructor for (1), (2), (3)
  • freeing
  • initializing (1), (2), (3)
  • last-access time
  • last-change time
  • last-modification time
  • memory duration of (1), (2), (3), (4)
  • obtaining
  • reference count
  • size
  • storage characteristics
• LOAD statement (1), (2)
• LoadLibrary() system call
• Local variable (1), (2), (3), (4)
• Locale
  • client (1), (2)
  • current processing (1), (2)
  • database (1), (2), (3)
  • in custom messages
  • name of
  • server (1), (2), (3), (4)
  • server-processing (1), (2), (3), (4)
• Lock
  • row
  • smart large object.
    • See also Smart-large-object lock.
  • table
• lock() system call
• Lock-all lock.
  • See also Smart-large-object lock, lock-all.
• Login name.
  • See also User account name.
• lohandles() support function
• LVARCHAR data type
  • See also Character data; mi_lvarchar data type.
  • as return value
  • as routine argument
  • casting from
  • casting from opaque type
  • corresponding DataBlade API data type (1), (2), (3), (4), (5), (6)
  • data conversion of
  • size restriction (1), (2), (3)
  • with opaque types
• lvarchar data type (ESQL/C).
  • See also mi_lvarchar data type.

• Machine notes
• Macro
  • for date and/or time qualifiers (1), (2)
  • for fixed-length data
  • for fixed-point data
  • for tracing
• Makefile
• malloc() system call (1), (2), (3), (4)
• memdur.h header file (1), (2)
• Memory context (1), (2), (3), (4), (5), (6), (7)
• Memory duration
  • See also individual memory durations.
  • advanced (1), (2), (3)
  • changing (1), (2)
  • choosing (1), (2)
  • collection descriptor (1), (2)
  • collection structure (1), (2)
  • connection descriptor (1), (2), (3), (4), (5)
  • constants for (1), (2)
  • current (1), (2), (3), (4)
  • deallocation and (1), (2), (3)
  • default (1), (2), (3)
  • defined (1), (2)
  • error descriptor (1), (2)
  • file descriptor (1), (2), (3)
  • function descriptor (1), (2), (3), (4), (5), (6)
  • groups of
  • LO file descriptor.
    • See also LO file descriptor, scope of.
  • LO handle (1), (2), (3), (4), (5)
  • LO-specification structure (1), (2), (3), (4)
  • LO-status structure (1), (2), (3), (4)
  • memory pools for (1), (2)
  • MI_FPARAM structure (1), (2), (3), (4), (5), (6), (7)
  • MI_LO_LIST structure
  • named memory
  • PER_COMMAND (1), (2), (3)
  • PER_CURSOR
  • PER_ROUTINE (1), (2), (3), (4)
  • PER_SESSION (1), (2), (3)
  • PER_STATEMENT, deprecated (1), (2), (3)
  • PER_STMT_EXEC (1), (2), (3)
  • PER_STMT_PREP (1), (2), (3)
  • PER_SYSTEM (1), (2), (3)
  • PER_TRANSACTION (1), (2), (3)
  • public (1), (2), (3), (4)
  • restoring
  • routine argument (1), (2)
  • routine return value
  • row descriptor (1), (2), (3)
  • row structure (1), (2), (3)
  • save-set structure (1), (2), (3)
  • session-duration connection descriptor (1), (2), (3)
  • session-duration function descriptor (1), (2)
  • specifying (1), (2)
  • statement descriptor.
    • See also Statement descriptor, scope of.
  • stream descriptor (1), (2), (3), (4)
  • switching
  • too large
  • too small
  • type descriptor
  • type identifier
  • user-defined error structure (1), (2)
  • user memory (1), (2), (3), (4)
  • varying-length structure (1), (2), (3)
• Memory management
  • See also Named memory; Thread stack; User memory.
  • accessing shared memory
  • caching memory
  • choosing memory duration (1), (2)
  • constructors.
    • See also Constructor.
  • DataBlade API data structures
  • destructors.
    • See also Destructor.
  • heap space (1), (2), (3), (4), (5), (6)
  • in C UDRs (1), (2), (3)
  • in callback functions
  • in client LIBMI applications
  • in DataBlade API functions
  • memory context (1), (2), (3), (4), (5), (6), (7)
  • memory duration.
    • See also Memory duration.
  • memory leaks (1), (2), (3), (4)
  • memory pools (1), (2), (3)
  • named memory
  • possible errors
  • saving memory address
  • shared memory (1), (2)
  • smart large objects
  • stack space
  • user memory (1), (2)
  • varying-length structures
• Memory pool.
  • See also Memory management, memory pools.
• Message log file (1), (2), (3), (4), (5), (6)
• MI_ABORT_END transition type (1), (2), (3)
• MI_All_Events event type, deprecated
• mi_alloc() function (1), (2), (3), (4), (5), (6), (7), (8), (9), (10)
• MI_BEGIN transition type
• MI_BINARY control-flag constant
• mi_binary_query() function (1), (2)
• mi_bitvarying data type
  • See also Byte data; Varying-length structure.
  • as routine argument
  • as routine return value
  • corresponding SQL data type (1), (2), (3)
  • defined
  • passing mechanism for
  • varying-length opaque type and (1), (2)
• mi_boolean data type
  • See also BOOLEAN data type.
  • corresponding SQL data type (1), (2)
  • format of (1), (2)
  • passing mechanism for (1), (2), (3)
  • portability of
  • type alignment
• mi_call() function
• mi_call_on_vp() function (1), (2)
• MI_CALLBACK_FUNC data type
• MI_CALLBACK_HANDLE data type
• MI_CALLBACK_STATUS data type (1), (2)
• mi_cast_get() function (1), (2), (3), (4), (5)
• MI_CB_CONTINUE callback-return constant (1), (2)
• MI_CB_EXC_HANDLED callback-return constant (1), (2), (3)
• mi_char data type
  • See also Character data.
  • corresponding SQL data type (1), (2)
  • defined
  • functions for
  • portability of
  • transferring between computers
  • type alignment
• mi_char data type; mi_lvarchar data type; mi_string data type.
• mi_char1 data type (1), (2), (3), (4), (5), (6)
  • See also Character data.
• mi_class_id() function
• mi_class_maxvps() function
• mi_class_name() function
• mi_class_numvp() function
• mi_client() function (1), (2)
• MI_Client_Library_Error event type
  • callback type for
  • connection descriptor for
  • default handling in client LIBMI
  • defined (1), (2)
  • in error descriptor (1), (2)
• mi_client_locale() DataBlade API function
• mi_client_locale() function
• mi_close() function
  • as destructor function (1), (2)
  • callback and
  • connection descriptor and (1), (2)
  • current statement and
  • cursor and (1), (2), (3)
  • function descriptor and
  • row descriptor and
  • row structure and
  • save set and
  • statement descriptor and (1), (2)
  • user memory and (1), (2)
• mi_close_statement() function (1), (2), (3)
• MI_COLL_DESC structure.
  • See also Collection descriptor.
• mi_collection_card() function
• mi_collection_close() function (1), (2), (3)
• mi_collection_copy() function (1), (2)
• mi_collection_create() function (1), (2), (3)
• mi_collection_delete() function (1), (2)
• mi_collection_fetch() function (1), (2), (3)
• mi_collection_free() function (1), (2), (3)
• mi_collection_insert() function (1), (2), (3)
• mi_collection_open() function (1), (2), (3)
• mi_collection_open_with_options () function (1), (2), (3)
• MI_COLLECTION structure.
  • See also Collection structure.
• mi_collection_update() function (1), (2)
• MI_COLLECTION_VALUE value constant (1), (2)
• mi_column_count() function (1), (2), (3)
• mi_column_id() function
• mi_column_name() function (1), (2)
• mi_column_nullable() function (1), (2)
• mi_column_precision() function (1), (2), (3), (4), (5)
• mi_column_scale() function (1), (2), (3)
• mi_column_type_id() function (1), (2), (3)
• mi_column_typedesc() function (1), (2), (3), (4)
• mi_command_is_finished() function (1), (2)
• MI_CONNECTION_INFO structure.
  • See also Connection-information descriptor.
• MI_CONNECTION structure.
  • See also Connection descriptor.
• MI_CONTINUE return constant
• mi_current_command_name() function (1), (2), (3)
• MI_CURSOR_ABSOLUTE cursor-action constant (1), (2)
• MI_CURSOR_ACTION data type (1), (2), (3)
• MI_CURSOR_CURRENT cursor-action constant
• MI_CURSOR_FIRST cursor-action constant (1), (2)
• MI_CURSOR_LAST cursor-action constant (1), (2)
• MI_CURSOR_NEXT cursor-action constant (1), (2)
• MI_CURSOR_PRIOR cursor-action constant (1), (2)
• MI_CURSOR_RELATIVE cursor-action constant (1), (2)
• mi_dalloc() function (1), (2), (3), (4), (5), (6), (7), (8), (9), (10)
• MI_DATABASE_INFO structure.
  • See also Database-information descriptor.
• mi_date data type
  • See also DATE data type.
  • byte order
  • character conversion
  • copying (1), (2)
  • corresponding SQL data type (1), (2), (3)
  • data conversion of
  • format of (1), (2)
  • functions for (1), (2), (3)
  • operations on (1), (2)
  • passing mechanism for (1), (2)
  • portability of
  • receiving from client
  • sending to client
  • transferring between computers
  • type alignment
• mi_date_to_string() DataBlade API function
• mi_date_to_string() function
• mi_datetime data type
  • See also DATETIME data type; dtime_t typedef.
  • arithmetic operations on
  • byte order
  • character conversion
  • copying (1), (2)
  • corresponding SQL data type (1), (2), (3)
  • data conversion of (1), (2)
  • extending
  • format of (1), (2)
  • functions for (1), (2)
  • inserting from (1), (2)
  • macros
  • passing mechanism for
  • portability of
  • qualifiers (1), (2)
  • receiving from client
  • selecting into (1), (2)
  • sending to client
  • transferring between computers
  • type alignment
• mi_datetime_to_string() function
• MI_DATUM data type
  • collection element as
  • column value as
  • defined (1), (2)
  • input-parameter value as (1), (2)
  • mi_call() and
  • opaque-type value in
  • OUT parameter as (1), (2)
  • promotion of (1), (2)
  • routine argument as (1), (2), (3), (4), (5)
  • routine return value as (1), (2), (3), (4), (5), (6), (7)
  • size of
• MI_DATUM structure
  • Boolean values in (1), (2)
  • characters in (1), (2), (3), (4)
  • contents of
  • date and time values in
  • date values in (1), (2)
  • decimal values in (1), (2), (3)
  • eight-byte integers in
  • floating-point values in (1), (2)
  • four-byte integers in
  • holding generic data value
  • interval values in
  • one-byte integers in
  • opaque-type value in
  • pointer values in (1), (2)
  • two-byte integers in
  • uses of
  • varying-length structures in
• MI_DATUM value
  • calculations with
  • collection element as (1), (2), (3)
  • column value as (1), (2), (3), (4), (5), (6), (7)
  • LO handle as (1), (2)
  • passed by reference
  • passed by value
• mi_db_error_raise() DataBlade API function
  • internationalization and
• mi_db_error_raise() function
  • connection descriptor and
  • exception message and
  • internationalization and
  • named-memory locks and
  • purpose of (1), (2)
• MI_DDL statement-status constant
• mi_decimal data type
  • See also DECIMAL data type; MONEY data type; dec_t typedef.
  • arithmetic operations on
  • byte order (1), (2)
  • character conversion (1), (2), (3), (4), (5)
  • copying (1), (2), (3)
  • corresponding SQL data type (1), (2), (3), (4)
  • data conversion of
  • declaring
  • double (C) conversion (1), (2)
  • format of (1), (2), (3), (4)
  • formatting
  • functions for (1), (2), (3), (4)
  • integer (2-byte) conversion
  • integer (4-byte) conversion
  • integer (four-byte) conversion
  • integer (two-byte) conversion
  • macros
  • mi_int8 conversion (1), (2)
  • passing mechanism for
  • portability of (1), (2)
  • receiving from client (1), (2)
  • role of decimal.h
  • sending to client (1), (2)
  • transferring between computers (1), (2)
  • type alignment (1), (2)
• mi_decimal_to_string() DataBlade API function
• mi_decimal_to_string() function
• mi_default_callback() function (1), (2)
• mi_disable_callback() function
• MI_DML statement-status constant (1), (2), (3)
• MI_DONE return constant
• mi_double_precision data type
  • byte order
  • copying (1), (2)
  • corresponding SQL data type (1), (2)
  • declaring
  • format of
  • functions for
  • mi_call() and
  • passing mechanism for
  • portability of (1), (2)
  • receiving from client
  • sending to client
  • transferring between computers
  • type alignment (1), (2)
• mi_drop_prepared_statement() function
  • purpose of (1), (2), (3), (4)
  • releasing resources (1), (2), (3)
  • restrictions on use
• mi_enable_callback() function
• mi_errmsg() function (1), (2), (3)
• mi_error_desc_copy() function (1), (2)
• mi_error_desc_destroy() function (1), (2)
• mi_error_desc_finish() function
• mi_error_desc_is_copy() function
• mi_error_desc_next() function
• MI_ERROR_DESC structure.
  • See also Error descriptor.
• mi_error_level() function (1), (2), (3), (4)
• MI_ERROR return code (1), (2), (3)
• mi_error_sql_state() function (1), (2), (3)
• mi_error_sqlcode() function (1), (2), (3)
• MI_EVENT_COMMIT_ABORT event type (1), (2), (3), (4), (5)
  • defined (1), (2), (3), (4), (5), (6)
• MI_EVENT_END_SESSION event type (1), (2), (3), (4), (5)
  • See also End-of-session callback.
  • as state transition
  • callback type for
  • defined (1), (2), (3), (4), (5), (6)
  • event-type structure for
• MI_EVENT_END_STMT event type (1), (2), (3), (4), (5), (6)
  • See also End-of-statement callback.
  • as state transition
  • callback type for
  • defined (1), (2), (3), (4), (5)
  • event-type structure for
• MI_EVENT_END_XACT event type (1), (2), (3), (4), (5), (6)
  • See also End-of-transaction callback.
  • as state transition
  • callback type for
  • defined (1), (2), (3), (4), (5)
  • event-type structure for
• MI_EVENT_POST_XACT event type (1), (2), (3), (4)
  • defined (1), (2), (3), (4), (5), (6)
• MI_EVENT_SAVEPOINT event type (1), (2), (3), (4), (5)
  • defined (1), (2), (3), (4), (5), (6)
• MI_EVENT_TYPE data type (1), (2), (3), (4), (5), (6)
• MI_Exception event type
  • callback type for (1), (2)
  • connection descriptor for (1), (2)
  • default handling in client LIBMI
  • default handling in UDR
  • defined (1), (2), (3)
  • in error descriptor (1), (2)
• MI_EXCEPTION exception level (1), (2), (3), (4), (5), (6), (7), (8), (9), (10)
• mi_exec() function
  • as an SQL command (1), (2)
  • as constructor
  • as parent connection
  • control mode and
  • database server exceptions and
  • purpose of (1), (2)
  • restrictions on use
  • smart large object and (1), (2)
  • when to use
• mi_exec_prepared_statement() function
  • as an SQL command (1), (2)
  • as parent connection
  • control mode and
  • database server exceptions and
  • executing iterator function
  • input parameter and
  • input parameters and
  • purpose of (1), (2)
  • restrictions on use
  • smart large object and (1), (2)
  • when to use
• mi_fetch_statement() function (1), (2)
• mi_file_allocate() function
• mi_file_close() function (1), (2), (3), (4)
• mi_file_errno() function (1), (2)
• mi_file_open() function (1), (2), (3), (4), (5)
• mi_file_read() function (1), (2), (3)
• mi_file_seek() function (1), (2)
• mi_file_sync() function (1), (2)
• mi_file_tell() function (1), (2)
• mi_file_to_file() function (1), (2), (3), (4)
• mi_file_unlink() function (1), (2), (3)
• mi_file_write() function (1), (2), (3)
• mi_fix_integer() function
• mi_fix_smallint() function
• mi_fp_argisnull() function (1), (2), (3), (4)
• mi_fp_arglen() function
• mi_fp_argprec() function (1), (2), (3), (4), (5)
• mi_fp_argscale() function (1), (2), (3)
• mi_fp_argtype() function (1), (2), (3)
• mi_fp_funcname() function
• mi_fp_funcstate() function (1), (2), (3), (4), (5), (6)
• mi_fp_getcolid() function
• mi_fp_getfuncid() function
• mi_fp_getrow() function
• mi_fp_nargs() function (1), (2)
• mi_fp_nrets() function (1), (2)
• mi_fp_request() function (1), (2), (3)
• mi_fp_retlen() function
• mi_fp_retprec() function (1), (2), (3), (4), (5)
• mi_fp_retscale() function (1), (2), (3)
• mi_fp_rettype() function (1), (2), (3)
• mi_fp_returnisnull() function (1), (2), (3)
• mi_fp_setargisnull() function (1), (2), (3), (4), (5), (6)
• mi_fp_setarglen() function (1), (2)
• mi_fp_setargprec() function (1), (2), (3), (4)
• mi_fp_setargscale() function (1), (2), (3)
• mi_fp_setargtype() function (1), (2), (3)
• mi_fp_setcolid() function
• mi_fp_setfuncid() function
• mi_fp_setfuncstate() function (1), (2), (3)
• mi_fp_setisdone() function (1), (2)
• mi_fp_setnargs() function (1), (2)
• mi_fp_setnrets() function
• mi_fp_setretlen() function
• mi_fp_setretprec() function (1), (2), (3), (4), (5)
• mi_fp_setretscale() function (1), (2), (3)
• mi_fp_setrettype() function (1), (2), (3)
• mi_fp_setreturnisnull() function (1), (2), (3), (4)
• mi_fp_setrow() function
• mi_fp_usr_fparam() function
• mi_fparam_allocate() function (1), (2), (3)
• mi_fparam_copy() function (1), (2), (3)
• mi_fparam_free() function (1), (2), (3)
• mi_fparam_get() function (1), (2), (3), (4)
• mi_fparam_get_current() function (1), (2)
• MI_FPARAM structure
  • absence of (1), (2)
  • accessor functions (1), (2), (3), (4)
  • allocating (1), (2), (3), (4), (5), (6)
  • argument length (1), (2)
  • argument precision (1), (2), (3), (4), (5), (6), (7), (8)
  • argument scale (1), (2), (3), (4)
  • argument type identifier (1), (2)
  • caching a connection descriptor in (1), (2), (3)
  • caching a function descriptor in
  • checking arguments in
  • checking return-value data types in
  • constructor for (1), (2), (3), (4)
  • copying
  • creating (1), (2), (3)
  • declaring (1), (2)
  • defined (1), (2), (3)
  • destructor for (1), (2), (3), (4)
  • determining who allocated
  • freeing (1), (2), (3)
  • from function descriptor
  • handling NULL arguments (1), (2), (3)
  • handling NULL return value (1), (2)
  • in function descriptor (1), (2)
  • iterator-completion flag (1), (2), (3)
  • iterator status (1), (2)
  • memory duration of (1), (2), (3), (4), (5), (6), (7)
  • number of arguments
  • number of return values
  • obtaining pointer to
  • return-value length (1), (2)
  • return-value precision (1), (2), (3), (4), (5), (6), (7), (8)
  • return-value scale (1), (2), (3), (4)
  • return-value type identifier (1), (2)
  • routine identifier
  • routine invocation and
  • routine name
  • routine sequence and
  • user-allocated (1), (2), (3), (4)
  • user-state pointer
  • using (1), (2), (3)
• mi_free() function
  • as destructor function (1), (2), (3), (4)
  • callback and
  • LO handle and
  • user memory and (1), (2), (3), (4)
• mi_func_commutator() function (1), (2)
• mi_func_desc_by_typeid() function (1), (2), (3), (4)
• MI_FUNC_DESC structure.
  • See also Function descriptor.
• mi_func_handlesnulls() function (1), (2), (3)
• mi_func_isvariant() function (1), (2)
• mi_func_negator() function (1), (2)
• MI_FUNCARG_COLUMN argument-type constant
• MI_FUNCARG_CONSTANT argument-type constant (1), (2)
• MI_FUNCARG data type (1), (2)
• mi_funcarg_get_argtype() function (1), (2)
• mi_funcarg_get_colno() function (1), (2), (3)
• mi_funcarg_get_constant() function (1), (2), (3)
• mi_funcarg_get_datalen() function (1), (2)
• mi_funcarg_get_datatype() function (1), (2)
• mi_funcarg_get_distrib() function (1), (2), (3)
• mi_funcarg_get_routine_id() function (1), (2)
• mi_funcarg_get_routine_name() function (1), (2)
• mi_funcarg_get_tabid() function (1), (2), (3)
• mi_funcarg_isnull() function (1), (2), (3), (4)
• MI_FUNCARG_PARAM argument-type constant
• MI_FUNCARG structure
  • accessor functions (1), (2), (3)
  • argument data type (1), (2)
  • argument length (1), (2)
  • argument type (1), (2)
  • column number (1), (2), (3)
  • defined (1), (2)
  • determining NULL argument (1), (2), (3)
  • routine identifier (1), (2)
  • routine name (1), (2)
  • table identifier (1), (2), (3)
• mi_funcid data type (1), (2)
• mi_get_bytes() function
• mi_get_connection_info() DataBlade API function
• mi_get_connection_info() function (1), (2), (3)
• mi_get_connection_option() function (1), (2)
• mi_get_connection_user_data() function (1), (2)
• mi_get_database_info() function (1), (2), (3), (4)
• mi_get_date() function
• mi_get_datetime() function
• mi_get_db_locale() function
• mi_get_decimal() function (1), (2)
• mi_get_default_connection_info() function (1), (2), (3), (4)
• mi_get_default_database_info() function (1), (2), (3), (4)
• mi_get_double_precision() function
• mi_get_id() function (1), (2)
• mi_get_int8() function
• mi_get_integer() function
• mi_get_interval() function
• mi_get_lo_handle() function (1), (2), (3)
• mi_get_money() function
• mi_get_next_sysname() function
• mi_get_parameter_info() function (1), (2)
• mi_get_real() function
• mi_get_result() function (1), (2), (3), (4), (5), (6), (7), (8), (9), (10)
• mi_get_row_desc() function (1), (2), (3)
• mi_get_row_desc_from_type_desc () function (1), (2), (3)
• mi_get_row_desc_without_row() function (1), (2), (3), (4), (5), (6)
• mi_get_serverenv() function
• mi_get_session_connection() function (1), (2)
  • restrictions on use
• mi_get_smallint() function
• mi_get_statement_row_desc() function (1), (2), (3), (4), (5), (6), (7)
• mi_get_string() DataBlade API function (1), (2)
• mi_get_string() function
• mi_get_type_source_type() function (1), (2)
• mi_get_vardata() function (1), (2), (3)
• mi_get_vardata_align() function (1), (2), (3), (4)
• mi_get_varlen() function (1), (2), (3)
• mi.h header file
  • advanced memory-management functions (1), (2)
  • client LIBMI applications and
  • DataBlade API data types
  • DataBlade API functions
  • defined
  • IBM Informix GLS library and
  • including in modules (1), (2), (3)
  • tracing
  • with restricted session-duration connections
  • with smart large objects
• mi_hdr_status() function
• MI_ID data type
• mi_impexp data type
  • See also IMPEXP data type; Varying-length structure.
  • contents of
  • corresponding SQL data type (1), (2)
  • defined
  • passing mechanism for
• mi_impexpbin data type
  • See also IMPEXPBIN data type; Varying-length structure.
  • contents of
  • corresponding SQL data type (1), (2)
  • defined
  • passing mechanism for
• mi_init_library() function
• mi_int1 data type (1), (2), (3)
• mi_int8 data type
  • See also INT8 data type; SERIAL8 data type.
  • arithmetic operations on
  • byte order
  • character conversion (1), (2)
  • copying
  • corresponding SQL data type (1), (2), (3)
  • data conversion of
  • double (C) conversion (1), (2)
  • float (C) conversion (1), (2)
  • format of (1), (2), (3)
  • functions for (1), (2), (3), (4)
  • integer (2-byte) conversion
  • integer (4-byte) conversion
  • integer (four-byte) conversion
  • integer (two-byte) conversion
  • mi_decimal conversion (1), (2)
  • passing mechanism for
  • portability of
  • receiving from client
  • role of int8.h
  • sending to client
  • transferring between computers
  • type alignment
• mi_integer data type
  • See also INTEGER data type; SERIAL data type.
  • byte order
  • copying
  • corresponding SQL data type (1), (2), (3)
  • format of (1), (2)
  • passing mechanism for (1), (2)
  • portability of (1), (2), (3)
  • receiving from client
  • sending to client
  • transferring between computers
  • type alignment
• mi_interval data type
  • See also INTERVAL data type; intrvl_t typedef.
  • arithmetic operations on
  • byte order
  • character conversion
  • copying (1), (2)
  • corresponding SQL data type (1), (2), (3)
  • data conversion of (1), (2)
  • extending
  • format of (1), (2)
  • functions for (1), (2)
  • inserting from (1), (2)
  • macros
  • passing mechanism for
  • portability of
  • qualifiers (1), (2)
  • receiving from client
  • selecting into (1), (2)
  • sending to client
  • transferring between computers
  • type alignment
• mi_interval_to_string() DataBlade API function
• mi_interval_to_string() function
• mi_last_serial() function
• mi_last_serial8() function
• MI_LIB_BADARG client-library error
• MI_LIB_BADSERV client-library error
• MI_LIB_DROPCONN client-library error
• MI_LIB_INTERR client-library error
• MI_LIB_NOIMP client-library error
• MI_LIB_USAGE client-library error
• mi_lo_alter() function (1), (2), (3), (4)
• MI_LO_APPEND access-mode constant (1), (2)
• MI_LO_ATTR_HIGH_INTEG create-time constant
• MI_LO_ATTR_KEEP_ LASTACCESS_TIME create-time constant (1), (2)
• MI_LO_ATTR_LOG create-time constant
• MI_LO_ATTR_MODERATE_ INTEG create-time constant
• MI_LO_ATTR_NO_LOG create-time constant
• MI_LO_ATTR_NOKEEP_ LASTACCESS_TIME create-time constant
• MI_LO_BUFFER buffering-mode constant (1), (2)
• mi_lo_close() function (1), (2), (3), (4), (5)
• mi_lo_colinfo_by_ids() function (1), (2), (3)
• mi_lo_colinfo_by_name() function (1), (2), (3)
• mi_lo_copy() function (1), (2), (3), (4), (5), (6), (7), (8), (9)
• mi_lo_create() function (1), (2), (3), (4), (5), (6), (7), (8), (9)
• mi_lo_decrefcount() function (1), (2), (3)
• mi_lo_delete_immediate() function (1), (2), (3), (4), (5)
• MI_LO_DIRTY_READ access-mode constant
• mi_lo_expand() function (1), (2), (3), (4), (5), (6), (7), (8), (9)
• MI_LO_FD data type.
  • See also LO file descriptor.
• mi_lo_filename() function (1), (2), (3)
• MI_LO_FORWARD access constant
• mi_lo_from_buffer() function (1), (2), (3), (4)
• mi_lo_from_file() function (1), (2), (3), (4), (5), (6), (7), (8), (9), (10), (11)
• mi_lo_from_file_by_lofd() function (1), (2), (3)
• mi_lo_from_string() function (1), (2), (3), (4), (5)
• MI_LO_HANDLE data type.
  • See also LO handle.
• mi_lo_increfcount() function (1), (2), (3)
• mi_lo_invalidate() function (1), (2), (3), (4)
• MI_LO_LIST structure (1), (2)
• mi_lo_lock() function (1), (2), (3)
• MI_LO_LOCKALL lock-mode constant (1), (2)
• MI_LO_LOCKRANGE lock-mode constant
• mi_lo_lolist_create() function (1), (2)
• MI_LO_NOBUFFER buffering-mode constant
• mi_lo_open() function (1), (2), (3), (4), (5), (6)
• mi_lo_ptr_cmp() function (1), (2)
• MI_LO_RANDOM access-method constant (1), (2)
• MI_LO_RDONLY access-mode constant (1), (2), (3)
• MI_LO_RDWR access-mode constant (1), (2)
• mi_lo_read() function (1), (2), (3), (4)
• mi_lo_readwithseek() function (1), (2), (3)
• mi_lo_release() function (1), (2), (3), (4), (5)
• MI_LO_REVERSE access constant
• mi_lo_seek() function (1), (2), (3), (4)
• MI_LO_SEQUENTIAL access-method constant
• MI_LO_SIZE constant
• mi_lo_spec_free() function (1), (2), (3), (4), (5)
• mi_lo_spec_init() function (1), (2), (3), (4), (5), (6)
• MI_LO_SPEC structure.
  • See also LO-specification structure.
• mi_lo_specget_def_open_flags() function (1), (2)
• mi_lo_specget_estbytes() function (1), (2)
• mi_lo_specget_extsz() function (1), (2)
• mi_lo_specget_flags() function (1), (2)
• mi_lo_specget_maxbytes() function (1), (2)
• mi_lo_specget_sbspace() function (1), (2)
• mi_lo_specset_def_open_flags() function (1), (2)
• mi_lo_specset_estbytes() function (1), (2)
• mi_lo_specset_extsz() function (1), (2)
• mi_lo_specset_flags() function (1), (2)
• mi_lo_specset_maxbytes() function (1), (2)
• mi_lo_specset_sbspace() function (1), (2)
• mi_lo_stat() function (1), (2), (3), (4), (5), (6)
• mi_lo_stat_atime() function (1), (2)
• mi_lo_stat_cspec() function (1), (2), (3), (4)
• mi_lo_stat_ctime() function (1), (2)
• mi_lo_stat_free() function (1), (2), (3), (4)
• mi_lo_stat_mtime_sec() function (1), (2)
• mi_lo_stat_mtime_usec() function (1), (2)
• mi_lo_stat_refcnt() function (1), (2), (3)
• mi_lo_stat_size() function (1), (2)
• MI_LO_STAT structure.
  • See also LO-status structure.
• mi_lo_tell() function (1), (2), (3), (4)
• mi_lo_to_buffer() function (1), (2), (3)
• mi_lo_to_file() function (1), (2), (3), (4), (5), (6)
• mi_lo_to_string() function (1), (2)
• MI_LO_TRUNC access-mode constant
• mi_lo_truncate() function (1), (2)
• mi_lo_unlock() function (1), (2), (3)
• mi_lo_utimes() function
• mi_lo_validate() function (1), (2), (3), (4)
• mi_lo_write() function (1), (2), (3), (4)
• mi_lo_writewithseek() function (1), (2), (3)
• MI_LO_WRONLY access-mode constant (1), (2)
• mi_lock_memory() function (1), (2)
• mi_lvarchar data type
  • See also LVARCHAR data type; Varying-length structure.
  • as internal format for character data
  • as opaque-type storage (1), (2), (3), (4)
  • as routine argument (1), (2), (3)
  • character conversion (1), (2)
  • contents of
  • converting between stream and internal
  • corresponding SQL data type (1), (2), (3), (4)
  • data conversion of
  • declaring
  • defined
  • passing mechanism for
  • reading from stream
  • uses of
  • varying-length opaque type and
• mi_lvarchar_to_string() function (1), (2), (3)
• MI_MEMORY_DURATION data type (1), (2), (3)
• MI_MESSAGE exception level (1), (2), (3), (4), (5), (6), (7), (8)
• mi_module_lock() function (1), (2)
• mi_money data type
  • See also mi_decimal data type; MONEY data type.
  • arithmetic operations on
  • byte order
  • character conversion
  • copying
  • corresponding SQL data type (1), (2)
  • data conversion of
  • format of (1), (2), (3), (4)
  • functions for (1), (2), (3)
  • macros
  • passing mechanism for
  • portability of
  • receiving from client
  • role of decimal.h
  • sending to client
  • transferring between computers
  • type alignment
• mi_money_to_string() DataBlade API function
• mi_money_to_string() function
• mi_named_alloc() function (1), (2), (3)
• mi_named_free() function
  • as destructor function (1), (2)
  • PER_SESSION memory and
  • PER_SYSTEM memory and
  • PER_TRANSACTION memory and
  • purpose of (1), (2)
  • session-duration function descriptors and
• mi_named_get() function (1), (2)
• mi_named_zalloc() function (1), (2), (3)
• mi_new_var() function (1), (2)
• mi_next_row() function (1), (2)
  • in a loop (1), (2)
  • overwriting buffer
  • purpose of (1), (2), (3), (4)
  • releasing resources
• MI_NO_MORE_RESULTS statement-status constant (1), (2), (3), (4), (5), (6), (7), (8), (9)
• MI_NO_SUCH_NAME return constant
• MI_NOMEM return constant
• MI_NORMAL_END transition type (1), (2), (3), (4)
• MI_NORMAL_VALUE value constant
• MI_NULL_VALUE value constant
• mi_numeric data type.
  • See also mi_decimal data type.
• MI_O_APPEND file-mode constant
• MI_O_CLIENT_FILE file-mode constant
• MI_O_EXCL file-mode constant
• MI_O_RDONLY file-mode constant
• MI_O_RDWR file-mode constant
• MI_O_SERVER_FILE file-mode constant
• MI_O_TEXT file-mode constant
• MI_O_TRUNC file-mode constant
• MI_O_WRONLY file-mode constant
• mi_open() function (1), (2), (3), (4), (5), (6)
• mi_open_prepared_statement() function (1), (2)
  • as an SQL command
  • control mode and
  • cursor name in
  • input parameter and
  • input parameters and
  • purpose of (1), (2)
  • restrictions on use
  • when to use
• mi_parameter_count() function (1), (2)
• MI_PARAMETER_INFO structure.
  • See also Parameter-information descriptor.
• mi_parameter_nullable() function (1), (2)
• mi_parameter_precision() function (1), (2), (3), (4), (5)
• mi_parameter_scale() function (1), (2), (3)
• mi_parameter_type_id() function (1), (2), (3)
• mi_parameter_type_name() function (1), (2)
• mi_pointer data type (1), (2), (3), (4), (5)
  • See also POINTER data type.
• mi_prepare() function (1), (2)
  • as constructor
  • assembling statement for
  • assigning a name
  • purpose of (1), (2), (3)
  • usage
• MI_PROC_CALLBACK constant
• mi_process_exec() function (1), (2)
• mi_put_bytes() function
• mi_put_date() function
• mi_put_datetime() function
• mi_put_decimal() function (1), (2)
• mi_put_double_precision() function
• mi_put_int8() function
• mi_put_integer() function
• mi_put_interval() function
• mi_put_lo_handle() function (1), (2)
• mi_put_money() function
• mi_put_real() function
• mi_put_smallint() function
• mi_put_string() DataBlade API function (1), (2), (3)
• mi_query_finish() function (1), (2), (3), (4), (5), (6), (7)
• mi_query_interrupt() function (1), (2), (3), (4)
• mi_real data type
  • See also SMALLFLOAT data type.
  • byte order
  • copying (1), (2)
  • corresponding SQL data type (1), (2)
  • declaring
  • format of
  • functions for
  • portability of (1), (2), (3), (4)
  • receiving from client
  • sending to client
  • transferring between computers
  • type alignment (1), (2)
• mi_realloc() function (1), (2), (3), (4), (5), (6), (7)
• mi_register_callback() function (1), (2)
• mi_result_command_name() function (1), (2), (3), (4), (5)
• mi_result_row_count() function (1), (2), (3), (4)
• mi_retrieve_callback() function
• mi_routine_end() function (1), (2), (3), (4)
• mi_routine_exec() function (1), (2), (3), (4)
• mi_routine_get() function (1), (2), (3), (4), (5)
• mi_routine_get_by_typeid() function (1), (2), (3), (4), (5)
• mi_routine_id_get() function (1), (2)
• mi_row_create() function (1), (2), (3), (4)
• mi_row_desc_create() function (1), (2), (3)
• mi_row_desc_free() function (1), (2), (3), (4)
• MI_ROW_DESC structure.
  • See also Row descriptor.
• mi_row_free() function (1), (2), (3), (4)
• MI_ROW structure.
  • See also Row structure.
• MI_ROW_VALUE value constant (1), (2)
• MI_ROWS statement-status constant (1), (2), (3), (4), (5), (6), (7), (8)
• mi_save_set_count() function
• mi_save_set_create() function (1), (2), (3), (4)
• mi_save_set_delete() function
• mi_save_set_destroy() function (1), (2), (3)
• mi_save_set_get_first() function (1), (2)
• mi_save_set_get_last() function
• mi_save_set_get_next() function (1), (2)
• mi_save_set_get_previous() function (1), (2)
• mi_save_set_insert() function (1), (2), (3)
• mi_save_set_member() function
• MI_SAVE_SET structure.
  • See also Save set; Save-set structure.
• MI_SEND_HOLD control-flag constant
• MI_SEND_READ control-flag constant
• MI_SEND_SCROLL control-flag constant
• mi_sendrecv data type
  • See also SENDRECV data type; Varying-length structure.
  • contents of
  • corresponding SQL data type (1), (2)
  • defined
  • passing mechanism for
• mi_server_connect() function (1), (2), (3)
• mi_set_connection_user_data() function (1), (2)
• mi_set_default_connection_info() function (1), (2), (3)
• mi_set_default_database_info() function (1), (2), (3)
• mi_set_parameter_info() function (1), (2)
• mi_set_vardata() function (1), (2), (3), (4)
• mi_set_vardata_align() function (1), (2), (3), (4)
• mi_set_varlen() function (1), (2)
• mi_set_varptr() function (1), (2)
• MI_SETREQUEST data type (1), (2)
• mi_sint1 data type (1), (2), (3)
• mi_smallint data type
  • byte order
  • copying
  • corresponding SQL data type (1), (2), (3)
  • format of (1), (2)
  • passing mechanism for (1), (2)
  • portability of (1), (2), (3)
  • receiving from client
  • sending to client
  • transferring between computers
  • type alignment
• MI_SQL message-type constant
• mi_stack_limit() function
• mi_statement_command_name() function (1), (2), (3), (4), (5)
• MI_STATEMENT structure.
  • See also Statement descriptor.
• mi_statret DataBlade API Data Type Structure
• mi_stream_close() function (1), (2), (3), (4), (5), (6)
• mi_stream_eof() function
• mi_stream_get_error() function
• mi_stream_getpos() function (1), (2), (3), (4)
• mi_stream_init() function (1), (2)
• mi_stream_length() function (1), (2), (3), (4)
• mi_stream_open_fio() function (1), (2), (3)
• mi_stream_open_mi_lvarchar() function (1), (2), (3)
• mi_stream_open_str() function (1), (2), (3)
• mi_stream_read() function (1), (2), (3), (4)
• mi_stream_seek() function (1), (2), (3), (4)
• mi_stream_set_error() function
• mi_stream_setpos() function (1), (2), (3), (4)
• mi_stream_tell() function (1), (2), (3), (4)
• mi_stream_write() function (1), (2), (3), (4)
• mi_streamread_boolean() function
• mi_streamread_collection() function (1), (2)
• mi_streamread_lo() function (1), (2)
• mi_streamread_lo_by_lofd() function
• mi_streamread_lvarchar() function (1), (2), (3)
• mi_streamread_row() function (1), (2)
• mi_streamread_string() function
• mi_streamwrite_boolean() function
• mi_streamwrite_collection() function
• mi_streamwrite_lo() function
• mi_streamwrite_lvarchar() function
• mi_streamwrite_row() function
• mi_streamwrite_string() function
• mi_string data type
  • See also Character data.
  • corresponding SQL data type (1), (2)
  • defined
  • functions for
  • mi_date conversion (1), (2)
  • mi_datetime conversion (1), (2)
  • mi_decimal conversion (1), (2)
  • mi_interval conversion (1), (2)
  • mi_lvarchar conversion (1), (2)
  • mi_money conversion (1), (2)
  • portability of
  • transferring between computers
  • type alignment
• mi_string_to_date() DataBlade API function
• mi_string_to_date() DataBlade API Function
• mi_string_to_datetime() function
• mi_string_to_decimal() DataBlade API function (1), (2)
• mi_string_to_interval() DataBlade API function
• mi_string_to_interval() function
• mi_string_to_lvarchar() function (1), (2), (3), (4), (5), (6), (7)
• mi_string_to_money() DataBlade API function
• mi_string_to_money() function
• mi_switch_mem_duration() function (1), (2), (3), (4), (5)
• mi_sysname() function
• MI_SYSTEM_CAST
• mi_td_cast_get() function (1), (2), (3), (4), (5), (6), (7), (8), (9), (10), (11)
• MI_TOOMANY return constant
• mi_tracefile_set() function (1), (2)
• mi_tracelevel_set() function (1), (2), (3)
• MI_TRANSITION_DESC structure
  • See also Transition descriptor.
• mi_transition_type() function (1), (2), (3)
• MI_TRANSITION_TYPE data type (1), (2), (3)
• mi_trigger_event() function
• mi_trigger_get_new_row() function
• mi_trigger_get_old_row() function
• mi_trigger_level() function
• mi_trigger_name() function
• mi_trigger_tabname() function
• mi_try_lock_memory() function (1), (2)
• mi_type_align() function
• mi_type_byvalue() function (1), (2), (3), (4), (5)
• MI_TYPE_DESC structure.
  • See also Type descriptor.
• mi_type_element_typedesc() function (1), (2)
• mi_type_full_name() function
• mi_type_length() function
• mi_type_maxlength() function
• mi_type_owner() function
• mi_type_precision() function (1), (2), (3), (4), (5), (6), (7)
• mi_type_qualifier() function (1), (2), (3), (4)
• mi_type_scale() function (1), (2), (3), (4), (5)
• mi_type_typedesc() function (1), (2)
• mi_type_typename() function (1), (2), (3), (4)
• mi_typedesc_to_id() function
• mi_typedesc_typeid() function
• MI_TYPEID data type.
  • See also Type identifier.
• mi_typeid_equals() function
• mi_typeid_is_builtin() function
• mi_typeid_is_collection() function
• mi_typeid_is_complex() function
• mi_typeid_is_distinct() function
• mi_typeid_is_list() function
• mi_typeid_is_multiset() function
• mi_typeid_is_row() function
• mi_typeid_is_set() function
• mi_typename_to_id() function
• mi_typename_to_typedesc() function
• mi_typestring_to_id() function
• mi_typestring_to_typedesc() function
• mi_udr_lock() function (1), (2)
• MI_UDR_TYPE data type
• mi_unlock_memory() function (1), (2), (3)
• mi_unregister_callback() function
• mi_unsigned_char1 data type (1), (2), (3), (4), (5), (6)
• mi_unsigned_int8 data type (1), (2), (3)
• mi_unsigned_integer data type (1), (2), (3), (4), (5)
• mi_unsigned_smallint data type (1), (2), (3), (4), (5)
• mi_value() function (1), (2), (3), (4), (5), (6), (7), (8)
• mi_value_by_name() function (1), (2), (3), (4), (5), (6), (7)
• mi_var_copy() function (1), (2), (3), (4)
• mi_var_free() function (1), (2)
• mi_var_to_buffer() function (1), (2)
• mi_vpinfo_classid() function (1), (2)
• mi_vpinfo_isnoyield() function
• mi_wchar data type
• mi_xa_get_current_xid() function
• mi_xa_get_xadatasource_rmid() function (1), (2)
• mi_xa_register_xadatasource() function
• mi_xa_unregister_xadatasource() function
• MI_Xact_State_Change event type
  • See also State-change callback.
  • as state transition (1), (2)
  • callback type for (1), (2)
  • connection descriptor for
  • default handling in client LIBMI
  • default handling in UDR
  • defined
  • event-type structure for (1), (2)
• mi_yield() function (1), (2)
• mi_zalloc() function (1), (2), (3), (4), (5), (6), (7), (8), (9), (10)
• miconv.h header file
• milib.h header file
• milo.h header file
  • access-method constants
  • access-mode constants
  • buffering-mode constants
  • create-time constants (1), (2)
  • defined (1), (2)
  • LO file descriptor
  • LO handle
  • LO-specification structure
  • LO-status structure
  • lock-mode constants
• minmdur.h header file (1), (2)
• minmmem.h header file (1), (2), (3), (4), (5)
• minmprot.h header file (1), (2), (3)
• mistream.h header file (1), (2), (3), (4), (5)
• mistrmtype.h header file (1), (2)
• mistrmutil.h header file (1), (2)
• mitrace.h header file (1), (2), (3)
• mitypes.h header file (1), (2)
• mmap() system call
• Module.
  • See also DataBlade API module.
• Monetary data
  • binary representation (1), (2), (3), (4)
  • end-user format for
  • text representation (1), (2), (3)
• Monetary string
  • converting from mi_money
  • converting to mi_money
  • data conversion of
  • defined
  • format of
• MONEY data type
  • See also mi_decimal data type; mi_money data type; Precision; Scale.
  • arithmetic operations on
  • corresponding DataBlade API data type (1), (2)
  • data conversion of
  • DataBlade API functions for (1), (2)
  • ESQL/C functions for (1), (2), (3)
  • format of (1), (2), (3)
  • functions for (1), (2), (3)
  • GLS library functions for
  • international money formats
  • macros
  • obtaining column value for
  • precision of
  • role of decimal.h (1), (2)
  • scale of
• msgget() system call
• MSGPATH configuration parameter
• MULTISET data type
  • See also SQL data type.
  • checking type identifier for
  • corresponding DataBlade API data type
  • format of
  • obtaining column value for