The London Perl and Raku Workshop takes place on 26th Oct 2024. If your company depends on Perl, please consider sponsoring and/or attending.

NAME

DBD::Illustra - Access to Illustra Databases

SYNOPSIS

use DBI;

DESCRIPTION

This document described DBD::Illustra version 0.02.

You should also read the documentation for DBI as this document qualifies what is stated there. This document was last updated for the DBI 1.02 specification, and the code requires at least release 1.0 of the DBI.

USE OF DBD::Illustra

Loading DBD::Illustra

To use the DBD::Illustra software, you need to load the DBI software.

    use DBI;

Under normal circumstances, you should then connect to your database using the notation in the section "CONNECTING TO A DATABASE" which calls DBI->connect().

You can find out which databases are available using the function:

    @dbnames=DBI->data_sources('Illustra');

Note that you may be able to connect to other databases not returned by this method. Also some databases returned by this method may be unavailable due to access rights or other reasons.

CONNECTING TO A DATABASE

The DBD::Illustra driver only supports the "new style" form of connect:

    $dbh = DBI->connect("dbi:Illustra:$database",$user,$pass);
    $dbh = DBI->connect("dbi:Illustra:$database",$user,$pass,\%attr);

The $database part of the first argument specifies the name of the database to connect to. Currently, only databases served by the default server may be connected.

DISCONNECTING FROM A DATABASE

You can also disconnect from the database:

    $dbh->disconnect;

This will rollback any uncommitted work. Note that this does not destroy the database handle. Any statements prepared using this handle are finished and cannot be used again.

AUTHOR

Peter Haworth (pmh@edison.ioppublishing.com)

SEE ALSO

perl(1), perldoc for DBI