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 extensionsYou 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 KitThe 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.
DBDK InfoShelfThe DataBlade® Developers Kit InfoShelf is designed to help you work with BladeSmith.
DataBlade® Developers Kit TutorialThe Tutorial is a set of exercises that demonstrate how to create extensions to HCL Informix® and package them as DataBlade® modules by using DBDK. Support for DataBlade Developers Kit (DBDK) is removed starting Informix Server 14.10.xC6.
Tutorial exercise 1: Creating a simple user-defined routineThis exercise demonstrates how to use the tools of the -- BladeSmith and the DBDK Visual C++ Add-In--to create a DataBlade® module with a user-defined routine and to debug it.
Using BladeSmith to generate the AddInts DataBlade® module and open the project file in Visual C++

Using BladeSmith to generate the AddInts DataBlade module and open the project file in Visual C++

About this task

To generate the AddInts DataBlade® module:

Procedure

Choose Generate > DataBlade.
With the DataBlade node at the top of the file tree selected, click Generate DataBlade.
After BladeSmith finishes generating code, click MSDev to start Microsoft™ Visual C++ and open the AddInts.dsw workspace file.

Results

BladeSmith generates the following files for your DataBlade module:

Table 1. Files generated by BladeSmith
Files	Description
Makefiles	The AddInts.dsw file is the makefile for Windows™ and the AddIntsU.mak file is the makefile for UNIX™. These files are generated in the AddInts\src directory. See the Informix® DataBlade Developers Kit User's Guide for instructions on compiling on UNIX.
Source code files	On Windows, you access these source code files through the AddInts.dsw file. Source code files are generated in the AddInts\src\c directory.
Unit test files	These files contain SQL statements to test your DataBlade module routines during debugging on Windows. Unit test files are generated in the AddInts\src\tests directory.
SQL scripts	These files are saved in the AddInts\scripts directory.
Functional test files	These files contain SQL statements to test your DataBlade module routines on UNIX after you finish debugging. Functional test files are generated in the AddInts\functest directory.
Installation files	These files are used by BladePack when you package your DataBlade module. Installation files are generated in the AddInts\install directory.

For more information about the Generate DataBlade command, see the Informix DataBlade Developers Kit User's Guide.

The BladeSmith portion of this exercise is complete; you can exit BladeSmith.

Rate this topic

5 stars 4 stars 3 stars 2 stars 1 star

Comment on this topic.

By clicking this box, you acknowledge that you are NOT a U.S. Federal Government employee or agency, nor are you submitting information with respect to or on behalf of one. HCL provides software and services to U.S. Federal Government customers through its partners immixGroup, Inc. Contact this team at https://hcltechsw.com/resources/us-government-contact. Do not include any personal data in this Comment box.