WDBI Informix Interface

The original Informix interface module for isqlperl was written by Curtis Wong (office curtis@ana.com, home curtis@crl.com) The current DBD::Informix module was written by Jeff Rowe (beowulf@lava.net).

Requirements

To use the WDBI Informix interface you will need Perl (version 5.004 or better).

You can find information about Perl at: http://www.perl.com.

You also need DBI and DBD::Informix. DBD::Informix is a set of user-defined subroutines letting you access an Informix data server using Perl. You will need the Informix development system to build DBD::Informix.

You can find out more about DBI and the DBD modules at: http://www.hermetica.com/technologia/perl/DBI/index.html

Configuration

Follow the normal WDBI configuration instructions, with the following exceptions :

• Set $DBI_FILE in the wdbi.conf file to informix_dbi.pl.
• In the init_vars() subroutine of the WDBI program:
  1. Set $ENV{'SQLEXEC'} to the path of your Informix server executable.
  2. Set $ENV{'INFORMIXDIR'} to the path of the root directory where your Informix files are located.
  3. Set $ENV{'DBDATE'} to the format in which you want dates to be displayed from the database (if you want something other than the default).

Creating FDF's

Included is also an Informix version of mkfdf, called informixfdf, which will produce a working template FDF file given a database and table name. Edit the informixfdf file (which is in the bin/ directory of this distribution) and set the variable $CONFIG_DIR to the path of the directory that contains the file 'informix_dbi.pl'.