Re: Anyone seen infoperl?

>There is now a perl interface to Informix SQL, available by anonymous >ftp from ftp.demon.co.uk in /pub/perl/db/isqlperl. 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 ol. >Enjoy. > =========================================================================== > | Bill Hails <bill@tardis.co.uk> | | > | C.L.I. Connect Ltd. | README: permission denied | > | 19, Quarry St., Guildford, Surrey | | > | GU1 3UY. Tel (UK) 0483 300 200 | | > =========================================================================== I have tried this, and it works quite well. I had some problems (I needed to recompile perl, as I couldn't locate uperl.o, and I think I goofed up some of the Configure answers), but once I got it compiled it worked well. EXCEPT -- when it retrieved a "serial" field, it only allotted 4 characters for the number in the sqlda. I'm not sure if it's my fault in compiling perl wrong, or if there really is a problem, but I hacked in a little "if" statement to increase the size, and it works fine. I'm using 5.01 OnLine with 4.00 perl (the latest I could find source for here). Basically, it handles up to a set number of select cursors, and will do an "execute immediate" for any other SQL. I've done some work retrieving rows from one database, processing them, and inserting into a different database; everything seems to work fine. Oh, and it DOES NOT seem to like BLOB fields... -- [ Ed Cardinal An English major from Berkeley ] [ Who sold out to programming ] [ cardinal@informix.com Because it pays more. ] [ DISCLAIMER: My Opinions. MINE! MINE! MINE! ]