Transactions Yes, if enabled when database was created Locking Yes, implicit and explicit Table joins Yes, inner and outer LONG/LOB datatypes Yes, up to 2 GB Statement handle attributes available After prepare( ) Placeholders Yes, "?" (native) Stored procedures Yes Bind output values Yes Table name letter case Configurable Field name letter case Configurable Quoting of otherwise invalid names Yes, via double quotes Case-insensitive "LIKE" operator No Server table ROW ID pseudocolumn Yes, "ROWID" Positioned update/delete Yes Concurrent use of multiple handles Unrestricted
Author and contact details
The driver author is Jonathan Leffler. He can be contacted via the dbi-users mailing list.
Supported database versions and options
DBD::Informix module supports Informix OnLine
and SE from version 5.00 onwards. There are some restrictions in the
support for IUS (a.k.a., IDS/UDO). It uses Informix-ESQL/C (a.k.a.,
Informix ClientSDK). You must have a development license for
Informix-ESQL/C (or the C-code version of Informix-4GL) to be able to
For more information, refer to:
Differences from the DBI Specification
If you change
AutoCommit after preparing a
statement, you will probably run into problems that you don’t
expect. So don’t do that.
DBD::Informix documentation for more details on this and other assorted ...