Perl DBI support for IDS has been around for a while, but not too many articles about it, so it's a refreshing change to see the new developerWorks tutorial by Daniel Herbert called Using Perl with the Informix Dynamic Server, which covers setting up the Perl Database Interface (DBI) to work with IDS, CPAN module installation, driver installation, script automation, data structures, pitfalls, Perl interaction with IDS (including using BLOBs and CLOBs).
You need to sign-in to developerWorks to access the tutorial which is in the form of a PDF file.[Read More]
Administrating and Developing with Informix
Matching: perl X
Trouble with Locales follow-up
Nobody likes it when they upgrade and their application stops working, which is probably why the Trouble with locales post from May generated more feedback than any other. Removing support for implicit locale conversion when DB_LOCALE settings were mismatched, thus introducing a potential backward incompatibility, was a regrettably unavoidable step to prevent the possibility of data corruption. A recent IIUG Forums mail highlighted the fact that some of the documentation covering Code-Set conversion is no longer correct (at the time of writing), like this example from the JDBC Programmer's Guide: Unicode to Database Code Set...
Gerardo Santana's Ruby driver for Informix has been updated to version 0.2.1. The new update is to fix some problems with free() calls which were causing crashes on Windows XP SP1. See the freshmeat page for details.
On the subject of Ruby, Informix Zone has added an article Talking with Perl, PHP, Python, Ruby to IDS showing Informix Dynamic Server programming examples for each of these free programming languages, including an overview of the "database abstraction layer" architecture they use.[Read More]