Adaptive Server Enterprise Extension Module for Perl

The Adaptive Server Enterprise extension module for Perl has been enhanced to support new attributes and methods, new Perl database and statement handle attributes, multiple statements, dynamic SQL, bind parameters, stored procedures, private driver methods, text and image data handling, and error handling.

Support for DSN Style Connection Properties
The driver uses a DSN mechanism that allows certain attributes to be set at connection time.
Currently Supported Database Handle Attributes
The table lists currently supported database handle attributes.
Perl Supported Datatypes
The Perl driver currently supports string, numeric, and date and time datatypes.
Multiple Statements Usage
Adaptive Server can handle multistatement SQL in a single batch.
Supported Character Lengths
Supported character lengths for different types of identifiers.
Configuring Locale and Charsets
You can configure the Perl driver of CT-Library locale and charset using the DSN attributes charset and language.
Dynamic SQL Support, Placeholders, and Bind Parameters
The Perl driver supports dynamic SQL, including parameter usage.
Stored Procedure Support for Placeholders
The Adaptive Server Enterprise database driver for Perl supports stored procedures that include both input and output parameters.
Supported Private Driver Methods
dbh->syb_isdead() returns a true or false representation of the state of the connection. A false return value may indicate a specific class or errors on the connection, or that the connection has failed.
Default Date Conversion and Display Format
You can set your own default date conversion and display format using the syb_data_fmt() private method.
Text and Image Data Handling
The Adaptive Server Enterprise database driver for Perl supports image and a text type for LONG/BLOB data. Each type can as much as 2GB of binary data.
Error Handling
All errors from the Adaptive Server database driver for Perl and CT-Lib are propagated into the DBI layer.
Configuring Security Services
Use the ocs.cfg and libtcl.cfg files to configure security options.
Examples
Use sample programs to view the basic usage of stored procedure and retrieve rows from the pubs2 authors table.

Parent topic: New Features for ESD #6