PEPPLER.ORG
Michael Peppler
Sybase Consulting
Menu
Home
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
Freeware
Sybperl
Sybase::Simple
DBD::Sybase
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
FAQs
Sybase on Linux FAQ
Sybperl FAQ
Personal
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

From: Michael Peppler <mpeppler at mbay dot net>
Subject: ANNOUNCE: sybperl 2.09
Date: Dec 31 1997 12:32AM

I have just uploaded sybperl 2.09 to CPAN - it will reach
your favorite site in a few days. Here's a brief description of
what has changed in this release:

This is sybperl 2.09.
---------------------

This release includes significant performance improvements, as 
well as now being portable to Win32 and VMS systems, as well as 
the traditional Unix systems, thanks to Charles Bailey for the 
VMS patches and Krzysztof Koczyjan for the Win32 patches.

Performance improvements:
-------------------------
The connection attributes ($dbh->{UseDateTime}, etc) used to be 
stored in real perl hash, which, when -DDO_TIE was set, would call 
some perl code every time you access it. It is now emulated (stored 
in a C struct) which improves speed tremedously (especially in DBlib
which makes heavy use of attributes).

dbnextrow() and ct_fetch() can now return a reference to a hash or an
array. This feature is enabled via a new $wantRef parameter to these
functions. The value of $wantRef defaults to false, to keep
compatibility with any old scripts.

This also improves speed because I can pre-allocate the array on the
first fetch, and then simply set the values as required on each
subsequent fetch.

Other enhancements:
-------------------
Certain connection properties can now be set when opening the
connection in Sybase::CTlib:

	  $dbh = new Sybase::CTlib $user, $pwd, $server, $appname,
	       { CON_PROPS => { CS_PACKETSIZE => 1024}};

The following properties are supported:
	CS_HOSTNAME
	CS_ANSI_BINDS
	CS_CHARSETCNV
	CS_PACKETSIZE
	CS_SEC_APPDEFINED
	CS_SEC_CHALLENGE
	CS_SEC_ENCRYPTION
	CS_SEC_NEGOTIATE

You can now specify date formats in Sybase::CTlib via the cs_dt_info()
call.

Sybase::DBlib now understands dbsetdefcharset() and dbsetdeflang().

Portability:
------------
Thanks to Charlse Bailey, sybperl 2.09 should build on VMS systems,
and thanks to Krzysztof Koczyjan it should also build on Win32 
systems - please see the README.win32 for details.


As usual comments, criticism, etc. welcome!

Michael
-- 
Michael Peppler       -||-  Data Migrations Inc.
mpeppler@datamig.com  -||-  http://www.mbay.net/~mpeppler