Home
Extending Informix®
Beyond standard relational database objects, HCL Informix® can be extended to handle specialized data types, access methods, routines, and other objects. Informix includes many built-in extensions that are fully integrated in the database server. Informix also provides DataBlade® modules, which are packages of extended database objects for a particular purpose and that are installed separately from the database server. Alternatively, you can create your own user-defined objects for Informix.
Creating extensions
You can create user-defined data types, routines, access methods, and other database objects to suit your needs. You can use application programming interfaces to write user-defined routines and applications that access data in Informix® databases.
DataBlade® API Programmer's Guide
The Informix® DataBlade® API Programmer's Guide describes information about the DataBlade API, the C-language application programming interface (API) provided with HCL Informix.
DataBlade® API overview
The DataBlade® API
The HCL Informix® DataBlade® API is the application programming interface (API) for HCL Informix. You can use DataBlade API functions in DataBlade modules to access data stored in the Informix database.
DataBlade® API components
The DataBlade® API contains the header files, public data type structures, and pubic functions for the development of DataBlade API modules.
Regular public functions
The DataBlade® API provides support for the functions in a DataBlade API module.
Informix® ESQL/C functions
In a DataBlade® API module, you can use some of the functions in the Informix® ESQL/C library functions to perform conversions and operations on different data types. The Informix ESQL/C functions do not begin with the mi_ prefix. Various header files declare these functions.

Extending Informix®
Beyond standard relational database objects, HCL Informix® can be extended to handle specialized data types, access methods, routines, and other objects. Informix includes many built-in extensions that are fully integrated in the database server. Informix also provides DataBlade® modules, which are packages of extended database objects for a particular purpose and that are installed separately from the database server. Alternatively, you can create your own user-defined objects for Informix.
- Informix® extensions and DataBlade® modules
  These topics describe how to use built-in database extensions and separately installed DataBlade® modules.
- Creating extensions
  You can create user-defined data types, routines, access methods, and other database objects to suit your needs. You can use application programming interfaces to write user-defined routines and applications that access data in Informix® databases.
  - DataBlade® API Programmer's Guide
    The Informix® DataBlade® API Programmer's Guide describes information about the DataBlade API, the C-language application programming interface (API) provided with HCL Informix.
    - DataBlade® API overview
      - The DataBlade® API
        The HCL Informix® DataBlade® API is the application programming interface (API) for HCL Informix. You can use DataBlade API functions in DataBlade modules to access data stored in the Informix database.
        The DataBlade® API module
        A DataBlade® API module is a C-language module that uses the functions of the DataBlade API to communicate with HCL Informix®.
        DataBlade® API components
        The DataBlade® API contains the header files, public data type structures, and pubic functions for the development of DataBlade API modules.
        Header files
        Public data types
        Regular public functions
        The DataBlade® API provides support for the functions in a DataBlade API module.
        DataBlade® API functions
        The DataBlade® API functions begin with the mi_ prefix. The milib.h header file declares most of these DataBlade API functions.
        Informix® ESQL/C functions
        In a DataBlade® API module, you can use some of the functions in the Informix® ESQL/C library functions to perform conversions and operations on different data types. The Informix ESQL/C functions do not begin with the mi_ prefix. Various header files declare these functions.
        Informix® GLS functions
        The library is an API that lets developers of DataBlade® API modules create internationalized applications. This library is a threadsafe library. The macros and functions of provide access to the GLS locales, which contain culture-specific information.
        Advanced features (Server)
        The DataBlade® API provides a set of advanced features to handle specialized needs of a UDR or DataBlade module that the regular public features cannot handle.
        Internationalization of DataBlade® API modules (GLS)
        For your DataBlade® API module to work in any HCL Informix® locale, you must implement your DataBlade API module so that it is internationalized. That is, the module must not make any assumptions about the locale in which it will execute.
      - Access SQL data types
        This section provides an overview of the data types that the DataBlade® API supports.
    - Data manipulation
    - Database access
    - Create user-defined routines
    - Appendix
      This section contains additional reference information.
  - DataBlade® API Function Reference
    The Informix® DataBlade® API Function Reference describes the DataBlade API functions and the subset of Informix ESQL/C functions that the DataBlade API supports.
  - DataBlade® Developers Kit
    The DataBlade® Developers Kit (DBDK) guides contain information about the tools you can use to develop and package DataBlade modules, which extend the functionality of HCL Informix® databases.
  - J/Foundation Developer's Guide
    The J/Foundation Developer's Guide describes how to write user-defined routines (UDRs) in the Java™ programming language for Informix®.
  - R-Tree Index User's Guide
    The Informix® R-Tree Index User's Guide describes the HCL Informix R-tree secondary access method and how to access and use its components.
  - User-Defined Routines and Data Types Developer's Guide
    The Informix® User-Defined Routines and Data Types Developer's Guide describes how to define new data types and enable user-defined routines (UDRs) to extend HCL Informix.
  - Virtual-Table Interface Guide
    The Informix® Virtual-Table Interface Programmer's Guide explains how to create a primary access method with the Virtual-Table Interface (VTI) so that users have a single SQL interface to HCL Informix tables and to data that does not conform to the storage scheme of HCL Informix.
  - Virtual-Index Interface Guide
    The Informix® Virtual-Index Interface Programmer's Guide explains how to create a secondary access method with the Virtual-Index Interface (VII) to extend the built-in indexing schemes of HCL Informix typically with a DataBlade® module.

Informix® ESQL/C functions

In a DataBlade® API module, you can use some of the functions in the Informix® ESQL/C library functions to perform conversions and operations on different data types. The Informix® ESQL/C functions do not begin with the mi_ prefix. Various header files declare these functions.

For more information, see ESQL/C header files.

The functions of the Informix® ESQL/C function library that are valid in a DataBlade® API module can be divided into the following categories.


Category of DataBlade® API function	More information
Byte handling	Manipulate byte data
Character processing	ESQL/C functions for string conversion Operations on character values
DECIMAL-type and MONEY-type processing	ESQL/C functions for decimal conversion Perform operations on decimal data
DATE-type processing	ESQL/C functions for date conversion Operations on date data
DATETIME-type processing and INTERVAL-type processing	ESQL/C functions for date, time, and interval conversion Operations on date and time data
INT8-byte processing	Convert INT8 values Perform operations on eight-byte values
Processing for other C-language data types	Format numeric strings

For a complete list of Informix® ESQL/C functions in each of these categories, see the Informix® DataBlade® API Function Reference, which provides descriptions of these public functions, in alphabetical order.