Subject: ANNOUNCE: sybperl 2.09
From: Michael Peppler <[email-masked]>
Date: 2 Jan 1998 23:55:16 GMT
Newsgroups: comp.lang.perl.announce,comp.lang.perl.modules

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.
[email-masked]  -||-  http://www.mbay.net/~mpeppler