The Adaptive Server Enterprise database driver for Perl in ESD #4 has the following feature enhancements.
See the Adaptive Server Enterprise database driver for Perl Programmers Guide.
New database handle attributes
New default date conversion and display format support using the new _data_fmt private method
New LONG/BLOB data handling support
Adaptive Server Enterprise database driver for Perl now supports an image and a text type for LONG/BLOB data. Each type can hold up to 2GB of binary data.
New automatic key generation support
Adaptive Server Enterprise database driver for Perl now supports an IDENTITY feature for automatic key generation. Declaring a table with an IDENTITY column generates a new value for each insert. The values are monotonically increasing, but are not guaranteed to be sequential. To fetch the value generated and used by the last insert:
SELECT @@IDENTITY
New parameter binding support
Adaptive Server Enterprise database driver for Perl now directly supports parameter binding. Only the '?' style parameters are supported; the ":1" placeholder type parameters are not supported. Binding a text or image datatype parameter is not supported.
New stored procedures with input and output parameters support