Technical Articles

The Technical Articles section provides a wide variety of detailed technical content covering a wide area of material which has been written by our technical team members.


Using Genero to improve application user productivity


Historically data input applications only allowed a user to access one part of the application at any one time. If a user needed to access another part of the application, for example to view customer details whilst updating an order, he or she would need to stop what they were doing and navigate to another part of the same application. As applications have grown larger and more complex this becomes a big user productivity drain.

This article describes how to solve this problem elegantly and simply in Genero, by allowing multiple modules of the same application to run concurrently in a single window.

Handling Concurrent Data Inputs and Displays in Genero


In the commercial world today we see growing complexity and depth in the information we store. A simple example would be a custom product or order line that is itself made up of many other products each with a variety of purchasing or build options. Historically data input applications did not support this type of requirement very well.

This article describes how to solve this programming problem by creating and using multiple active input arrays and data input fields in Genero.

MS-SQL Informix SE Linked Server



Microsoft SQL Server is a popular choice for consolidation of report data from multiple database products, as its Linked Server feature - which is included in the base product - makes it possible to access tables in heterogeneous databases within T-SQL via OLE DB or ODBC.

However, the settings are not obvious that are required to make this work with Informix Standard Engine (SE) - the legacy version of Informix that uses C-ISAM to store tables (*.dat) and indexes (*.idx) in individual files (whereas Dynamic Server manages storage within its own "dbspaces").

IDS 11+ sysadmin:alertcleanup function bug fix


This article describes a bug in a function provided with IBM Informix Dynamic Server (IDS) which could result in disk space being filled. We have reported this to IBM who have assigned defect number (APAR) IT09329. Meanwhile, you can fix your system using code provided below.

Little known IDS commands: onsecurity


Continuing the series of seldom used commands lurking in the bin directory of your Informix installation directory, today we’re looking at onsecurity.

It is very important to keep your database server and associated files secure; as well as keeping your data safe, later versions of IDS will refuse to start should the base ownership and permissions be too insecure. If your installation has been moved or copied, or other files or directories been added over time, IDS may not be running in the most secure environment.