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® 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.
DataBlade® Developers Kit User's Guide
The HCL Informix® DataBlade® Developers Kit User's Guide describes how to use tools to develop and package DataBlade modules.
Getting started with DataBlade® module development
This section provides an overview of DataBlade® module development and describes the resources and tools the HCL Informix® database server provides to facilitate development.
Prepare to develop DataBlade® modules
This section suggests how to prepare for developing DataBlade® modules. This overview is intended to act as a map for information resources.
Become familiar with HCL Informix® software and documentation
Familiarizing yourself with HCL Informix® software and documentation is critical for first-time DataBlade® developers. However, it is important for experienced DataBlade developers too, because HCL Informix software and documentation are enhanced in each release.

Extending Informix®
Beyond standard relational database objects, HCL Informix® can be extended to handle specialized data types, access methods, routines, and other objects. Informix includes many built-in extensions that are fully integrated in the database server. Informix also provides DataBlade® modules, which are packages of extended database objects for a particular purpose and that are installed separately from the database server. Alternatively, you can create your own user-defined objects for Informix.
- Informix® extensions and DataBlade® modules
  These topics describe how to use built-in database extensions and separately installed DataBlade® modules.
- Creating extensions
  You can create user-defined data types, routines, access methods, and other database objects to suit your needs. You can use application programming interfaces to write user-defined routines and applications that access data in Informix® databases.
  - DataBlade® API Programmer's Guide
    The Informix® DataBlade® API Programmer's Guide describes information about the DataBlade API, the C-language application programming interface (API) provided with HCL Informix.
  - DataBlade® API Function Reference
    The Informix® DataBlade® API Function Reference describes the DataBlade API functions and the subset of Informix ESQL/C functions that the DataBlade API supports.
  - 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.
    - DataBlade® Module Development Overview
      The HCL Informix® DataBlade® module overview serves as an overview of the HCL Informix DataBlade module development process.
    - DataBlade® Developers Kit User's Guide
      The HCL Informix® DataBlade® Developers Kit User's Guide describes how to use tools to develop and package DataBlade modules.
      - Getting started with DataBlade® module development
        This section provides an overview of DataBlade® module development and describes the resources and tools the HCL Informix® database server provides to facilitate development.
        What is a DataBlade® module?
        A DataBlade® module is a software package that extends the functionality of your HCL Informix® database server. The package includes SQL statements and supporting code written in an external language or Informix SPL.
        tools
        Prepare to develop DataBlade® modules
        This section suggests how to prepare for developing DataBlade® modules. This overview is intended to act as a map for information resources.
        Become familiar with HCL Informix® software and documentation
        Familiarizing yourself with HCL Informix® software and documentation is critical for first-time DataBlade® developers. However, it is important for experienced DataBlade developers too, because HCL Informix software and documentation are enhanced in each release.
        Software requirements for DataBlade® module development
        Install and become familiar with your database server, Informix® Client Software Development Kit, and .
        DataBlade® Developers Kit Tutorial
        The Tutorial offers several exercises, each focusing on a single aspect of DataBlade® module development.
        Create a practice DataBlade® module
        To familiarize yourself with the entire development process, create a simple practice DataBlade® module containing an easily implemented object, such as a user-defined routine that takes built-in data types as arguments.
        Design your DataBlade® module
        DataBlade® modules can contain complex operations. A good design is critical to your success.
        Develop your DataBlade® module
        Developing your DataBlade® module is an iterative process that involves creating objects in BladeSmith, generating code, editing and compiling code, and testing and debugging code.
      - Design DataBlade® modules
        This section describes the DataBlade® module SQL design issues.
      - Programming guidelines
        Use this section to help you when you write the design specification for your DataBlade® module.
      - Create DataBlade® objects by using BladeSmith
        Use BladeSmith to create DataBlade® modules.
      - Programming DataBlade® module routines in C
        This section contains information to help you edit and compile C language source code generated by DataBlade®.
      - Create ActiveX value objects
        This section describes how to use the to create ActiveX value objects. This section describes the use of C++ to implement opaque type support routines.
      - The ActiveX value objects
        This section provides information for client application developers who are using ActiveX value objects.
      - Programming DataBlade® modules in Java™
        This section contains information to help you edit and compile Java™ language source code generated by BladeSmith.
      - Debugging and testing DataBlade® modules on UNIX™
        This section describes how to debug and perform functional tests for DataBlade® modules written in C for Informix® on UNIX™.
      - Debugging and testing DataBlade® modules on Windows™
        This section describes how to debug and perform functional tests for DataBlade® modules written in C and C++ for Informix® on Windows™.
      - BladePack
        BladePack creates installation packages for DataBlade® modules and other software products.
      - Appendixes
        This section contains additional reference information.
    - DBDK InfoShelf
      The DataBlade® Developers Kit InfoShelf is designed to help you work with BladeSmith.
  - 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.

Become familiar with HCL Informix® software and documentation

Familiarizing yourself with HCL Informix® software and documentation is critical for first-time DataBlade® developers. However, it is important for experienced DataBlade® developers too, because HCL Informix® software and documentation are enhanced in each release.

To familiarize yourself with HCL Informix® products and documentation:

Read Informix® DataBlade® Module Development Overview.
This publication briefly describes the database objects you can include in your DataBlade® module and other options you have when you create a DataBlade® module.
Install the necessary HCL Informix® software.
See Software requirements for DataBlade module development for more information.
Learn to use HCL Informix® software: at the least, your database server, the Setnet32 utility (client connectivity), and the DB-Access or SQL Editor utilities (SQL querying).
Complete the Tutorial.
See DataBlade Developers Kit Tutorial for more information.
Create your own practice DataBlade® module.
See Create a practice DataBlade module for more information.