NAME

DBD::Plibdata - a DBI driver for Jenzabar's Plibdata/cisaps access method for CX systems

SYNOPSIS

 use strict;
 use DBI;
 my $dbh = DBI->connect("dbi:Plibdata:host=$HOSTNAME;port=$PORT", 
                     $USERNAME, $PASSWORD, {PrintError => 0});
 my $sql = "SELECT fullname FROM id_rec WHERE id = 1";
 my ($name) = $dbh->selectrow_array($sql);
 
 $sql =<<EOT;
 SELECT txt
 FROM runace_aps 
 WHERE ace = '/opt/carsi/install/arc/hr/acereport.arc'
 AND params = '';
 EOT
 my ($acetxt) = $dbh->selectrow_array($sql);

DESCRIPTION

Jenzabar's Plibdata provides access to many appservers including ACE reports via runace_aps. It also supports rudimentary SQL statements.

Parameters for DBI->connect()

* host. Required. Hostname of Plibdata/cisaps server.

* port. Required. Service name in /etc/services or port number.

Database Handle Attributes

* plb_RowsPerPacket. Range: 1 - 255. Default: 40. This is the number of rows the server will return in one fetch. Although performance on multiple row queries can increase by setting this higher than the default, keep in mind that since the client caches every received row, memory usage will grow proportionally.

UNSUPPORTED

 . SQL is not parsed except for bind variable markers (question marks). 
 . Blank passwords
 . Aggregate functions
 . Calls to stored procedures
 . CREATE, DROP, SELECT INTO, etc.
 . SERIAL8, INT8, BYTE, BLOB/CLOB probably don't work
 

AUTHOR

Stephen Olander-Waters < stephenw AT stedwards.edu >

LICENSE

Copyright (c) 2005-2007 by Stephen Olander-Waters, all rights reserved.

You may freely distribute and/or modify this module under the terms of either the GNU General Public License (GPL) or the Artistic License, as specified in the Perl README file.

No Jenzabar code or intellectual property was used or misappropriated in the making of this module.

SEE ALSO

DBI, DBD::Informix, DBI::DBD, IO::Socket::INET, Digest::MD5