The following is a list of sites known to contain Informix-related archives or files. Included with each is a brief description of the archive contents and how to obtain more information.
You might also try searching on the keyword "informix" using your favorite Net utility like archie, etc.
This listing originated in the file " /pub/informix/doc/archive_sites" in the FTP archive on ftp.iiug.org (also mirrored at quasar.ucar.edu). Walt will be posting all-new editions to c.d.i. around the first of each month.
An on-line electronic information service offered by Informix Software, Inc., for a subscription fee. Contains bug lists, workarounds, technical tips, product and marketing information. Available via interactive dial-up access, and now through The Web. The home page is at
http://www.informix.comCall +1 800 331 1763 (USA) or your local Informix Software representative. Informix's contact is Sheryl Ingravallo (sheryl@informix.com), +1 650 926 6355
(walt@mathcs.emory.edu (Walt Hultgren {rmy}))
$cust_code = "A001A" @cust_array = `echo 'select cust_name from cust_table where customer=\"$cust_code\" ' | $dbaccess database_name-`; $cust_name = $cust_array[4];
Bill Hails writes:
There is now a perl interface to Informix SQL, available by anonymous ftp from ftp.demon.co.uk as pub/perl/db/isqlperl/isqlperl-1.2.shar.Z You'll need perl already installed, and you'll need Informix ESQL/C installed to build it also.
This is not the notorious (and mythical) Infoperl, rather it's my reaction to finally discovering that Infoperl never existed. Nor is it DBperl compliant, so it will undoubtedly be supplanted by DBperl in the not too distant future.
I've tested it on Informix 4.10 SE and Online.
Note: isqlperl is not compatible with Perl 5 -- you need Perl 4 to use it.
Jonathan Leffler (johnl@informix.com) updates
---------------------------------------------------------------------------
Where is DBD::Informix
======================
The latest version of DBD::Informix should be available by accessing:
http://www.hermetica.com/technologia/perl/DBIYou can also go to CPAN (Comprehensive Perl Archive Network) via:
http://www.perl.org/CPAN/modules/by-moduleThere are two sub-directories: DBI for the latest version of DBI, and DBD for the latest version of DBD::Informix and all the other DBD modules.
In case of doubt, I use the FTP site:
ftp://wcarchive.cdrom.com/perl/CPAN/modules/by-module/DBDThis is based in Walnut Creek, near San Francisco, CA, USA. There may well be another CPAN mirror site closer to you -- check in the web pages for The Perl Institute http://www.perl.org Note that CPAN automatically multiplexes your download requests to a mirror site near you.
Last updated: 1999-09-19 for DBI-1.02 and DBD::Informix Version 0.62
I am in the process of converting a major internet sub-site from oraperl to Vortex perl. We looked at the shareware DBI version, and I followed the list for a while. My impression is if you are strong in Unix C and have the time to play with it, it is probably a fine way to go. If not, Trifox has a product that, so far, looks like it will work just fine. However, it is not free ( but you can pick up a phone and have an intellegent person assisting you if you need). You can check them out at http://www.trifox.com
On 1st Oct 1998 pmh@edison.ioppublishing.com (Peter Haworth) wrote:-
The URL
ftp://ftp.iop.org/outgoing/pmh/DBD-Illustra-0.03.tar.gzLast updated: 1998-10-12 for DBD::Illustra Version 0.03
Dr. Richard Spitz says:
There is a freeware package released by Genentech Inc. called DSQL which consists of a server for Unix/VMS and several clients for Unix,DOS and Mac. It may take some tweaking to get the server compiled and running for your system, but the Mac part seems to be pretty straightforward.
I am not a Mac person, but our Mac people liked the hypercard stack very much with which they could interface to our Informix databases on our Unix hosts. There is also a programming API to integrate database access into your own programs.
You can get dsql from cgl.ucsf.edu (128.218.14.2), I don't know the exact directory.
Nothing that will produce anything like .4gl code from a .4go, anyway. There is an internal tool for analyzing .4go files that is called the "decompiler" internally, but its output is too terse to be useful for much except debugging fglpc and fglgo.
A list of GUI builders & front-ends appears in Appendix G
db4glgen
Dave Snyder's excellent 4GL code generator for simple single table maintenance-style forms. Provides a good skeleton for more sophisticated maintenance programs too. ftp://ftp.iiug.org/pub/informix/das/SHELL/db4glgen.sh
dbdiff2
Jack Parker's excellent database comparison tool. Identifies differences in database structure between two databases, and generates appropriate SQLs to bring them in sync. ftp://ftp.iiug.org/pub/informix/pub/dbdiff2.Z
4gltags
Generate tag files for use with the vi editor. Increased my programming productivity enormously! Get it from ftp://ftp.iiug.org/pub/informix/pub/4gltags_awk.Z a C-based version is available at: ftp://ftp.iiug.org/pub/informix/pub/4gltags_c.Z
vie
Edit .err directly to fix compilation errors. Another superb productivity gain. Requires use of the vi editor. ftp://ftp.iiug.org/pub/informix/das/SHELL/vie.sh
query_window
Essentially you pass a SELECT statement to the routine and it builds a pick-list window. Pretty damn flexible. Pretty damn easy to use. Does NOT use arrays. Optionally forces a Query-by-Example selection before displaying the pick-list. I like it a lot, but then I wrote it.
ftp://ftp.iiug.org/pub/informix/pub/query_win.Z
reform
David Cortesi (cortesi@informix.com) has a nice utility ftp://ftp.iiug.org/pub/informix/pub/reform_sql.Z capable of reformating ISQL vertical-format reports from this:
# order_num 1007 # order_date 03/25/1989 # customer_num 117 # backlog n # po_num 278693 # ship_date 04/23/1989 # ship_weight 125.90
into a horizontal format like this:
# order_num order_date customer_num backlog po_num ship_date ship_weight # 1007 03/25/1989 117 n 278693 04/28/1989 125.90 # 1012 06/05/1989 117 n 278701 06/09/1989 70.80InxUtil
The latest versions of the tools of Tim Schaefer
for 4GL, and DBA work are available at www.inxutil.com
and updated frequently. There is also a monthly electronic magazine
highlighting Informix tools and events, for developers and end users.
4gl Works
Marco Greco has made available a small subset of his "4glWorks" product (an Application Framework for 4GL) at www.ctonline.it/~marcog/4glworks.htm
marcog@linux.ctonline.it (Marco Greco) writes: Informix is no longer shipping the source code, but the compiled libraries instead. The only ports available are HPUX, AIX & Solaris - and this poses some problems for the SCO users. Jonathan told me that he's trying to convince whoever is in charge to put back the source code on Informix www site. It'll take some time though.
A Web interface to SQL Databases. WDB was originally written as an interface to Sybase but now, thanks to Curtis Wong, it also has an interface to Informix.
From the announcement...
All there is needed to use WDB is the WDB script (written in Perl) and a set of high-level form definition files, each describing a different view on the database. WDB automatically creates HTML forms, on-the-fly, to allow the users to query the database, and given the users query constraints it will query the database and present the result to the user. WDB even comes with a utility to automatically extract information about a table from the database and create a working template form definition file.
WDB is a cgi-script written in Perl for NCSA's HTTP server. WDB was written for the ESO and ST-ECF science data archive.
More information and instructions on how to download and install it is available at http://arch-http.hq.eso.org/bfrasmus/wdb/wdb.html
For an example of what a WDB interface to a database looks like try the Hubble Space Telescope Science Exposures form at:
http://arch-http.hq.eso.org/cgi-bin/wdb/hst/science/form
dbCGI is an unsupported, free software product of CorVu Pty Ltd.
dbCGI uses embedded SQL in HTML documents to execute database queries and format the results. It has support for Progress, Sybase, Oracle, Informix, Ingres and ODBC(whatever that means) databases, including BLOB data, such as images, sound and video.
Jeff Rowe has great gobs of interesting information on all the products mentioned above, plus more, at:
http://cscsun1.larc.nasa.gov/~beowulf/db/existing_products.html and http://cscsun1.larc.nasa.gov/~beowulf/db/web_access.htmlOn 5th Oct 1998 dbruce@us.dhl.com (David Bruce) wrote:-
We use the following from the Washington Area (DC) IUG:
http://www.iiug.org/~waiug/iugnew63.htm#testOn 19th Jan 1999 tbryan@arlut.utexas.edu (Tom Bryan) wrote:-
The Python database modules with Informix (see http://www.python.org/topics/database/modules.html)On 7th August 1999 leopold_the_cat@yahoo.com (Leopold The Cat) wrote:-
http://www.informix.com/answers/english/pdf_docs/23sdk/5445.pdfOn 6th September 1999 paul@oninit (Paul Watson) wrote:-
Having been pestered for sysmaster information on and off for a while I collected some of my notes together on extracting information from sysmaster and put them on our website. The URL is
http://www.oninit.com/oninit/sysmaster/index.htmlOn 15th May 2005 david@smooth1.co.uk (David Williams) wrote:-
Try http://www.oninit.com/onstat/index.html