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.
AGS Server Studio & Sentinel are the tools of choice for day-to-day Informix DBA tasks, SQL development and system monitoring. For those who have been using it as long as we have, it is worth recapping on some of the features added since our version 7 video demos at http://www.serverstudio.co.uk were created.
With Informix versions 11.50, 11.70 and 12.10 IBM has introduced an array of new configuration parameters that support new advanced capabilities and provide increased flexibility and agility. With all of these versions IBM has also introduced greater self-management capability meaning that the database server can more readily adapt to its environment and workload – the database server itself takes control over part of its run-time configuration.
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.
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.
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").