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.
DataBlade® Module Development OverviewThe HCL Informix® DataBlade® module overview serves as an overview of the HCL Informix® DataBlade® module development process.
DataBlade® module concepts
DataBlade® modules and the database serverThis section describes the overall architecture of the HCL Informix® database server, how DataBlade® modules affect database server processes, and the application programming interfaces you can use in your DataBlade® modules and client applications.
DataBlade® module programming languages
Informix® Stored Procedure LanguageYou can use HCL Informix® Stored Procedure Language (SPL) statements to write routines, and you can store these SPL routines in the database.

Informix Stored Procedure Language

You can use HCL Informix® Stored Procedure Language (SPL) statements to write routines, and you can store these SPL routines in the database.

Informix SPL is an extension to SQL that provides flow control, such as looping and branching. SPL routines can execute routines written in C or other external languages, and external routines can execute SPL routines.

You can use SPL routines to perform any task that you can perform in SQL and to expand what you can accomplish with SQL alone. SPL routines are parsed and optimized when they are created. The DataBlade® Developers Kit enables you to include SPL statements to create routines. For more information about SPL, see the Informix Guide to SQL: Tutorial.

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.