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.
Header files
Private header files
If you define any opaque data types, you must include their header file in your DataBlade® API source code. An opaque-type header file usually contains the declaration of the internal format for the opaque data type.

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
        DataBlade® API header files
        The DataBlade® API header files begin with the mi prefix. The DataBlade API provides public header files for use in DataBlade API modules.
        ESQL/C header files
        Header files are provided to support some of the functions and data types of the Informix® ESQL/C library.
        Informix® GLS header file
        A header file is provided to support the library. If you use the library in your DataBlade® API module, include its header file, ifxgls.h, in your source code.
        Private header files
        If you define any opaque data types, you must include their header file in your DataBlade® API source code. An opaque-type header file usually contains the declaration of the internal format for the opaque data type.
        Public data types
        Regular public functions
        The DataBlade® API provides support for the functions in a DataBlade API module.
        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.

Private header files

If you define any opaque data types, you must include their header file in your DataBlade® API source code. An opaque-type header file usually contains the declaration of the internal format for the opaque data type.